没有,我的建库命令是 CREATE TABLESPACE mydb DATAFILE 'D:\test\mydb' SIZE 5M AUTOEXTEND ON NEXT 1M;CREATE USER mydb IDENTIFIED BY j123456 DEFAULT TABLESPACE mydb PROFILE DEFAULT ACCOUNT UNLOCK; GRANT CONNECT TO mydb WITH ADMIN OPTION; GRANT AQ_ADMINISTRATOR_ROLE TO mydb WITH ADMIN OPTION; GRANT DBA TO mydb WITH ADMIN OPTION; GRANT UNLIMITED TABLESPACE TO mydb ; ALTER USER mydb DEFAULT ROLE ALL; commit;然后imp命令导入备份数据库
CREATE TABLESPACE mydb DATAFILE 'D:\test\mydb' SIZE 5M AUTOEXTEND ON NEXT 1M;CREATE USER mydb IDENTIFIED BY j123456 DEFAULT TABLESPACE mydb PROFILE DEFAULT ACCOUNT UNLOCK;
GRANT CONNECT TO mydb WITH ADMIN OPTION;
GRANT AQ_ADMINISTRATOR_ROLE TO mydb WITH ADMIN OPTION;
GRANT DBA TO mydb WITH ADMIN OPTION;
GRANT UNLIMITED TABLESPACE TO mydb ;
ALTER USER mydb DEFAULT ROLE ALL;
commit;然后imp命令导入备份数据库