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

zhangliao613

于 2011-03-27 15:05:00 发布

阅读量1k

点赞数

CC 4.0 BY-SA版权

分类专栏： DB - Oracle 文章标签： database logging file user table

本文链接：https://blog.youkuaiyun.com/zhangliao613/article/details/6281535

DB - Oracle 专栏收录该内容

39 篇文章

订阅专栏

本文详细介绍如何在Oracle数据库中创建表空间、用户并授予相应权限的过程，包括设置表空间属性、用户默认表空间及临时表空间等操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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