I use under the system user exp export tr_xxxx a table, then in another database for import, prompt ora - 01435, but I have created the corresponding table space, and then I take the initiative to create a user, the ora - 16000 error, but I use the alter database open read write into 06596. After using the alter session set container=PDB and after $SEED into the ora - 16000
Could you tell me how to handle the ah, imp import when I added ignore=y full=y

CodePudding user response:

Wrong number is ora - 65096

CodePudding user response:

Now add the fromuser and touser, imp - 00403

CodePudding user response:

ORA - 65096: invalid common user or role name
Cause: An attempt was made to create a common user or role with a name that was
Not valid for common users or roles. In addition to the usual rules for user and role
Names, common user and role names must start with c # # or # # and consist only of
ASCII characters.
Action: Specify a valid common user or role name.

Are you from oracle11g export table, to oracle12c import

CodePudding user response:

The

reference 3 floor liuzhijian2008x response:

ORA - 65096: invalid common user or role name
Cause: An attempt was made to create a common user or role with a name that was
Not valid for common users or roles. In addition to the usual rules for user and role
Names, common user and role names must start with c # # or # # and consist only of
ASCII characters.
Action: Specify a valid common user or role name.

Are you from oracle11g export table, to oracle12c import

Yes, can't do this operation?

CodePudding user response:

reference 4 floor qq_24073571 response:

Quote: reference liuzhijian2008x reply: 3/f

ORA - 65096: invalid common user or role name
Cause: An attempt was made to create a common user or role with a name that was
Not valid for common users or roles. In addition to the usual rules for user and role
Names, common user and role names must start with c # # or # # and consist only of
ASCII characters.
Action: Specify a valid common user or role name.

Are you from oracle11g export table, to oracle12c import

Yes, can't do this operation?

12 c username and 11 g, ordinary users to begin with c # #

CodePudding user response:

To create a common database or data warehouse