Oracle数据库基本操作

1.登录sqlplus

2.创建名称空间
create tablespace "SCD_GZSEITBS0" DATAFILE 'E:\oracle_data\chuangda\SCD_CCSEI.DBF' SIZE 2G AUTOEXTEND ON NEXT 500M;
3.创建用户并指定表空间
CREATE USER SCD_CCQSEI IDENTIFIED BY CCQSEI DEFAULT TABLESPACE SCD_GZSEITBS0;
grant resource to "SCD_CCQSEI" --授权
grant connect to "SCD_CCQSEI" 
grant dba to "SCD_CCQSEI"
4.创建数据目录
create or replace directory gzfs_datapath as 'E:\oracle_data\datapath\gzfscc';
5.导出
expdp SCD_JSDTSEI/SCD_JSDTSEI@ORCL schemas=SCD_JSDTSEI dumpfile=JSDTSEI181012.dmp DIRECTORY=gzfs_datapath 
6.导入
impdp SCD_CCQSEI/CCQSEI@ORCL directory=gzfs_datapath  REMAP_SCHEMA=SCD_JSDTSEI:SCD_CCQSEI dumpfile=JSDTSEI181012.DMP  full=y