oracle常用语句

--创建数据表空间
create tablespace xxxxxx_data logging datafile 'D: 2_toolsoracledatafilexxxxxx_data01.dbf'
size 512m  
autoextend on  
next 50m maxsize 2048m;
--创建索引表空间
create tablespace xxxxxx_idx logging datafile 'D: 2_toolsoracledatafilexxxxxx_idx01.dbf'
size 512m  
autoextend on  
next 50m maxsize 2048m;
--创建临时表空间
create temporary tablespace xxxxxx_temp tempfile 'D: 2_toolsoracledatafilexxxxxx_temp01.dbf'
size 512m  
autoextend on  
next 50m maxsize 2048m;

--创建用户语句
create user xxxxxx
  identified by xxxxxx
  default tablespace xxxxxx_DATA
  temporary tablespace xxxxxx_TEMP;

--开发环境授权语句
grant connect,resource,dba to xxxxxx;

--创建dir语句
create DIRECTORY dump_dir AS 'E: 1_workdump_dir';

--授权dir语句
GRANT READ, WRITE ON DIRECTORY dump_dir TO xxxxxx;

--导出语句
expdp xxxxxx/[email protected] DIRECTORY=dump_dir DUMPFILE=xxxxxx_v1_1_05.DMP

--导入dmp
impdp xxxxxx/[email protected]  dumpfile=xxxxxx_V1_0_02.dmp directory=DUMP_DIR REMAP_SCHEMA=from_user:to_user  remap_tablespace=from_tablespace:to_tablespace