Re: Help using IMP/EXP utility

From: BJ <bernhard.jongejan_at_born2run.tmfweb.nl>
Date: Sat, 21 Jul 2001 13:04:20 +0200
Message-ID: <9jbnm5$qfp$1@cyan.nl.gxn.net>

1 do the export
2 do an import with the import option indexfile = create_obj

this will create a file with the ddl for the objects to be imported 3 edit this file and alter the tablespace names, i prefer to use vi or ultraedit
4 create the objects with the edited create_obj 5 start the import but don't forget to remove the indexfile option

or move the tables afterwards using move with nologging and tables with rebuild with nologging

regards

Bernhard Jongejan

bernhard.jongejan_at_topficie.nl

Baba Yetunde <nospam_at_nospam.com> schreef in berichtnieuws pk167.16598$tc3.1067136_at_news1.cableinet.net...
> 1) How can I used this tool to move objects out of one TABLESPACE to
> another?
>
>
Received on Sat Jul 21 2001 - 06:04:20 CDT