创建空间用户并赋权限，导入dmp

来源：互联网发布：广东网络作协编辑：程序博客网时间：2024/06/04 18:44

CREATE SMALLFILE TABLESPACE "TS_AIAHK" DATAFILE 'D:/ORADATA/TS_AIAHK' SIZE 1G AUTOEXTEND ON NEXT 250M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

CREATE USER "IAMP_SIT" PROFILE "DEFAULT" IDENTIFIED BY "password" DEFAULT TABLESPACE "TS_AIAHK" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK;
GRANT "CONNECT" TO "IAMP_SIT";

GRANT CREATE PROCEDURE TO "IAMP_SIT";
GRANT CREATE TABLE TO "IAMP_SIT";
GRANT CREATE TRIGGER TO "IAMP_SIT";
GRANT CREATE TYPE TO "IAMP_SIT";
GRANT CREATE VIEW TO "IAMP_SIT";
GRANT CREATE SEQUENCE TO "IAMP_SIT";
GRANT "CONNECT" TO "IAMP_SIT";
GRANT "OEM_MONITOR" TO "IAMP_SIT";
GRANT "EXP_FULL_DATABASE" TO "IAMP_SIT";
GRANT "IMP_FULL_DATABASE" TO "IAMP_SIT";
GRANT "RESOURCE" TO "IAMP_SIT";

alter user IAMP_SIT quota unlimited on TS_AIAHK;

imp iamp_sit/password@gdb full=y file=E:/ZL/AIAHK/20110323/iamp_sit_20110323.dmp

imp 'sys/password@gdb as sysdba' fromuser=iamp_sit touser=iamp_sit file=E:/ZL/AIAHK/20110323/iamp_sit_20110323.dmp ignore=Y