Chmouel Blog

Renaming Oracle Database is a pain, coming from OpenSource DB like
MySQL or PostGres where we do that all the time i did not think that
Oracle have to be such a pain.

My only way i can find.

- If i have the tablespace named tablesp1 and owned by the
user user1, and i want to import it to another tablespace
called tablesp2 in an another Oracle 9i tablespace with the user
name user2.

• I import the tablesp1 in an Oracle 10 (if you are lucky to have
  one).
• Make sure i create the user2 in the Oracle10 DB.
• I connect as DBA access and i rename the tablespace with :

  ALTER TABLESPACE tablesp1 RENAME TO tablesp2
  ALTER TABLESPACE tablesp2 OWNER TO user2
    

• Export the Oracle10 tablespace with Oracle 9 exp.
  Sometime sometime you may encounter that famous error

  "EXP-00003 : no storage definition found for segment .....".
  

  So you have have to
  do this as well.

• That’s it. The dump should be under tablespace name tablesp2 with
  owner user2.

Filed under: Oracle on February 7th, 2007