oralce使用imp导入dmp时报错

[qq_24073571]

我在system用户下使用exp导出tr_xxxx的一个表，然后在另外一个数据库进行导入的时候，提示ora-01435，但是我已经创建了对应的表空间。然后我主动创建用户的时候，出现了ora-16000的错误，但是我使用alter database open read write之后又变成了06596.使用alter session set container=PDB$SEED之后又变成了ora-16000
请问该怎么处理啊，imp导入的时候我加了ignore=y full=y

[liu志坚]

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 c## and consist only of ASCII characters. Action: Specify a valid common user or role name. 你是从oracle11g 导出的表，到oracle12c导入的吧

[qq_24073571]

引用 3 楼 liuzhijian2008x 的回复:

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 c## and consist only of ASCII characters. Action: Specify a valid common user or role name. 你是从oracle11g 导出的表，到oracle12c导入的吧

是的，是不是不能这么操作啊？

[liu志坚]

引用 4 楼 qq_24073571 的回复:

[quote=引用 3 楼 liuzhijian2008x 的回复:] 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 c## and consist only of ASCII characters. Action: Specify a valid common user or role name. 你是从oracle11g 导出的表，到oracle12c导入的吧

是的，是不是不能这么操作啊？[/quote] 12C的用户名和11G不一样了。普通用户要以C##开头命名

[学海无涯-回头是岸]

创建的普通数据库还是数据仓库

[qq_24073571]

打错了 是ora-65096

[qq_24073571]

现在加上了fromuser和touser之后，出现imp-00403