How to put the Oracle 11 g database import export to 12 c? ! Duang ~ ~ ~-CodePudding

Hand data derived from 11 g, project with 12 c database, the data import to 12 c, is always an error " Oracle encounters an error 1435 "

With the SYS new OWBSYS user, the user name must be the c # # OWBSYS , and this is not what I want OWBSYS ~ ~

CodePudding user response:

LZ provide your imp and exp command line, may be you have several export user, when you import, there is no these users (in part),

CodePudding user response:

How to export and import?

CodePudding user response:

reference 1st floor wmxcn2000 response:

LZ provide your imp and exp command line, may be you have several export user, when you import, there is no these users (in part),

thank you for your answer! Is indeed does not exist when the import OWBSYS this user, so I try to use new user OWBSYS SYS, the results are as follows:

So I checked the, 12 c new CBD and PDB module (this is my reference site: http://www.cnblogs.com/dingyingsi/p/3604789.html),
But this can only be new public user: c # # OWBSYS

This is not I want to OWBSYS users,

CodePudding user response:

refer to the second floor jdsnhan response:

how to export, and how to import?

database is exported, the main problem is in 12 c I built a public user, and public user must begin with '# #', as if about 12 c additional CDB and PDB, I am watching now, is not very understand,

CodePudding user response:

The building Lord solved?

CodePudding user response:

I also encountered similar problems, solve the building Lord, solution to tell you, thank you very much

CodePudding user response:

SQL> @ cat_owb
Enter in Tablespace Name for OWBSYS user:
The users
Package created.
Package body created.
The Create user OWBSYS with default in tablespace users...
Old 1: CREATE USER OWBSYS IDENTIFIED BY OWBSYS DEFAULT in TABLESPACE & amp; Owbsys_tbs
New 1: CREATE USER OWBSYS IDENTIFIED BY OWBSYS DEFAULT in TABLESPACE users
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
User created.
The User altered.

NOTE: To associate the Control Center with the correct OWB home, now run OWB UnifiedRepos/reset_owbcc_home. SQL. You must run the script. As a user with Java admin privileges. For example, connect the as sys as sysdba To run the script.
SQL> SQL> SQL> SQL>

SQL> @ reset_owbcc_home
Enter the full path of the Oracle home for OWB Control Center install.
If you are installing in a Windows environment, both please ensure that the case of the path exactly matches the Oracle install path o the drive letter.
OWB Control Center Home:
/usr/local/oracle/product/11.2.0/dbhome_1
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.

CodePudding user response:

 
1, the newly built a PDB 
2, modify tnsnames. Ora increase a point to PDB TNS 
3, when impdp @ new TNS 


But if you don't understand the PDB, it is best not to use, to install a database, to install, remember not to check the PDB options

CodePudding user response:

Derivative in CDB according to you?

CodePudding user response:

Derivative from other versions, according to the data can only be imported into the PDB