Method 1 for modifying schemas in Oracle

Method 1 for modifying schemas in Oracle

Because of service requirements, you need to rename one of schemas. You can find two rename methods after Oracle 11.2.0.2.

Method 1: Use the import/export method to modify schemas.
• Do a user-level export of user
• Create new user B
• Import system/manager fromuser = A touser = B
• Drop user

Test environment: the database has schemas ADM_IDCS and needs to be renamed to ADM_JDCS.

Procedure:

A) create an ADM_JDCS user with the same Permissions

Create user ADM_IDCS

Identified by 'adm _ IDCS'

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMP

PROFILE DEFAULT

Account unlock;

B) Export of adm_idcs

Expdp system/oracle directory = dir dumpfile = full1.dmp schemas = adm_idcs

C) Import adm_idcs

Impdp system/oracle directory = dir dumpfile = full1.dmp fromuser = adm_idcs touser = adm_jdcs

D) Delete the original adm_idcs user

Drop user adm_idcs cascade;

After the preceding operations, modify adm_idcs to adm_jdcs.