Home » RDBMS Server » Server Utilities » How to rename a tablespace using import
How to rename a tablespace using import [message #69504] Tue, 22 January 2002 05:50 Go to next message
cacael
Messages: 8
Registered: January 2002
Junior Member
I've 2 databases DB1 an DB2. Talespace db1_ts1 and db1_ts2 are in database DB1. Want to move data from db1_ts1 and db1_ts2 to another tablespace db2_ts . Db2_ts tablespace is in the second database DB2. I want to use import utility , but i dont know what parameter i must set in my parfile ; can you help me ?
Re: How to rename a tablespace using import [message #69512 is a reply to message #69504] Thu, 24 January 2002 05:13 Go to previous messageGo to next message
Ajay Gandhi
Messages: 14
Registered: January 2002
Junior Member
There is no way you can rename the tablespace name. If you want to move objects from one tablespace to another, your best bet is to pre-create the objects (empty) into the second tablespace and run the import with ignore=Y

Re: How to rename a tablespace using import [message #69520 is a reply to message #69504] Fri, 25 January 2002 01:34 Go to previous messageGo to next message
Keshav Tripathy
Messages: 30
Registered: November 2001
Member
There is no such process to rename the Tablespaces
Name. What you have to do is to have the index during export and use that index to create the objects in the Target Tablespace.
Re: How to rename a tablespace using import [message #69531 is a reply to message #69504] Sun, 27 January 2002 13:38 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
set default tablespace of the user u want to import as db2_ts and assign quota in that tablespace to user .
Previous Topic: oracle
Next Topic: export - ORA-00904
Goto Forum:
  


Current Time: Fri Mar 29 09:28:19 CDT 2024