-
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
-
do a table level export. TABLE=schema.tablename DIRECT=Y
COMPRESS=N
Sam
Thanx
Sam
Life is a journey, not a destination!
-
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.
Reddy,Sam
-
What option do you specify to get the INDEX FILE.
-
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.
Reddy,Sam
-
Don't forget to include the import option IGNORE=Y if you pre-create the table.
HTH
David.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|