oralce使用imp匯入dmp時報錯-有解無憂

我在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

uj5u.com熱心網友回復：

打錯了是ora-65096

uj5u.com熱心網友回復：

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

uj5u.com熱心網友回復：

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匯入的吧

uj5u.com熱心網友回復：

參考 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匯入的吧

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

uj5u.com熱心網友回復：

參考 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匯入的吧

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

12C的用戶名和11G不一樣了。普通用戶要以C##開頭命名

uj5u.com熱心網友回復：

創建的普通資料庫還是資料倉庫

轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/70784.html

標籤：基礎和管理

上一篇：oracle 資料庫查詢問題

下一篇：oracle12c安裝程序出現oracle database configutation assistant