• Create external user (using OPS$)
• Create User like...

0@@

1@@

2@@

If the user is very large, it can take a very long time to use the standard way expdp / impdp.<br /> It can be done more efficiently using transportable tablespaces technique to remap the schema.

• Rename an Oracle Schema using Transportable Tablespace

Basic steps

• check with DBMS_TTS.TRANSPORT_SET_CHECK that tablespace can be transported
• Make the tablespace read only
• Export tablespace metadata
• Drop the tablespace but keep its datafiles
• Create the new user account representing the renamed schema and grant needed privileges
• Import tablespace metadata and rename schema objects owner at the same time
• Make tablespce read write
• Set password for new user account and set default tablespace for this new account
• Drop old user account representing the schema before renaming

An unsupported workaround to rename a schema is to simply update the username in sys.user$ and restart the database.

3@@

4@@

5@@

6@@

7@@

8@@

Watch out on Windows - the domain name needs to be included!

9@@

Additionally, the following option must be set in “%ORACLE_HOME%\network\admin\sqlnet.ora”<br /> If this is not present, you will not be able to connect as sysdba

10@@