Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: tips on moving oracle to new machine
"Howard J. Rogers" <howardjr_at_www.com> wrote in message
news:39c86b17_at_news.iprimus.com.au...
> You might want to consider the INDEXFILE option of the import command: it
> create a text file which contains the SQL statements necessary to
re-create
> indexes and tables. The create table statements are all remm'ed out, but
> it's a quick fix to edit the file and remove the rems. You then have a
> script that will reconstruct all tables and indexes (assuming you
specified
> full=y). It can be edited to make the 'tablespace' bits refer to any
> tablespace you fancy.
This is the way to go, but go further: Get this script, uncomment the table creation statements, and edit all the tablespace clauses on both table and index statements to what you want. Create all the tablespaces and run this script to create all the objects. Then do the import and tell it to ignore object creation errors. It'll put each table's data in the tablespace where you created it earlier.