搞定,分用户导入了! 1.先建表空间,再建PVUSER用户,分配quotas CREATE USER "PVOAS" IDENTIFIED BY "pvoas" DEFAULT TABLESPACE "PVUSER_MAIN" TEMPORARY TABLESPACE "PVUSER_TMP" PROFILE DEFAULT QUOTA UNLIMITED ON "PVUSER_MAIN" QUOTA UNLIMITED ON "PVUSER_TMP" ACCOUNT UNLOCK; GRANT "CONNECT" TO "PVOAS"; ALTER USER "PVOAS" DEFAULT ROLE ALL;2.中途出错了用drop user pvuser cascade;再重复1的步骤3.用如下命令导入 imp80 system/manager fromuser=pvuser touser=pvuser indexes=y buffer=10240000 ignore=y file=d:\expmin.dmp log=d:\expmin.log grants=y4.编译有问题的存储过程
1.先建表空间,再建PVUSER用户,分配quotas
CREATE USER "PVOAS" IDENTIFIED BY "pvoas" DEFAULT TABLESPACE "PVUSER_MAIN" TEMPORARY TABLESPACE "PVUSER_TMP" PROFILE DEFAULT QUOTA UNLIMITED ON "PVUSER_MAIN" QUOTA UNLIMITED ON "PVUSER_TMP" ACCOUNT UNLOCK;
GRANT "CONNECT" TO "PVOAS";
ALTER USER "PVOAS" DEFAULT ROLE ALL;2.中途出错了用drop user pvuser cascade;再重复1的步骤3.用如下命令导入
imp80 system/manager fromuser=pvuser touser=pvuser indexes=y buffer=10240000 ignore=y file=d:\expmin.dmp log=d:\expmin.log grants=y4.编译有问题的存储过程