export option

[badrinathn]

Hi,

I am trying to export a table and want to import it into a different tablespace. What option should I include in the export scripts, so that I can change the tablespaces or the column name etc


I have a ora 7.3 which doen't have move option

Badrinath

[sambavan]

do a table level export. TABLE=schema.tablename DIRECT=Y
COMPRESS=N

Sam

[sreddy]

Edit the index file and change the tablespace and create object(table) by running that script. Then try import the table, it works and loads the table you created.

Thought to add on for what sambavan mentioned.

[badrinathn]

What option do you specify to get the INDEX FILE.

[sreddy]

export the table and import with SHOW=Y and that gives all the definitions of Indexes and reference tables with "REM" clause prefixed.

Remove REM clause for table definitions and remove index definitions(unless you want to point indexes to different tablespace) and run that script.

Bottom line, If you have object(table, index) exists import will not try to create but just loads the data. If you donot have it it tries to create.

[Dave_A]

Don't forget to include the import option IGNORE=Y if you pre-create the table.

HTH

David.