删除命名空间 drop tablespace CHINESE including contents and datafiles cascade constraints;
首先用户 drop user CHINESE cascade;
再执行,
CREATE TABLESPACE CHINESE--建立表空间
LOGGING
DATAFILE 'D:\app\Administrator\oradata\CHINESE\DEMO_20151015.DBF' SIZE 1G--单引号中的文件为随机文件,可以自行指定位置
AUTOEXTEND ON NEXT 100M MAXSIZE 2G
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;
CREATE USER CHINESE--建立用户
PROFILE DEFAULT
IDENTIFIED BY CHINESE
DEFAULT TABLESPACE CHINESE
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED ON CHINESE
ACCOUNT UNLOCK;
ALTER USER CHINESE DEFAULT ROLE ALL;
GRANT CONNECT,
CREATE PROCEDURE,
CREATE TRIGGER,
ANALYZE ANY,
CREATE TYPE,
SELECT ANY DICTIONARY,
CREATE VIEW,
CREATE SEQUENCE
TO CHINESE;
GRANT ALTER ANY TABLE TO CHINESE;
GRANT DROP ANY TABLE TO CHINESE;
GRANT DELETE ANY TABLE TO CHINESE;
GRANT SELECT ANY TABLE TO CHINESE;
GRANT INSERT ANY TABLE TO CHINESE;
GRANT CREATE ANY TABLE TO CHINESE;
GRANT CREATE TYPE TO CHINESE;
GRANT CREATE PUBLIC DATABASE LINK TO CHINESE;
GRANT DROP PUBLIC DATABASE LINK TO CHINESE;
GRANT DBA TO CHINESE;
数据泵工具导出的步骤:
1、创建DIRECTORY
create directory DR_DBIMP as 'D:\DR_DBIMP';--导入的数据库所在的位置
2、授权
Grant read,write on directory DR_DBIMP to CHINESE;
以下这句话在“运行”中输入cmd后,执行;不是在sqlplus中执行
impdp CHINESE/CHINESE@CHINESE directory=DR_DBIMP DUMPFILE=DEMO_20151015.DMP LOGFILE=DEMO_20151015.log REMAP_SCHEMA=(CS42DEMO:CHINESE) REMAP_TABLESPACE=(CS42DEMO:CHINESE)。
REMAP_SCHEMA=(CS42DEMO:CHINESE) REMAP_TABLESPACE=(CS42DEMO:CHINESE),这句话冒号前边的是原来的用户和表空间,冒号后面的是现在建立的用户和表空间