常用基本语句（积累）持续更新......

/*查看数数据库的状态*/

select instance_name,ststus from v$instance;

/*查看数据库数据文件*/
select *  from dba_data_files;


/*创建一个表空间*/
create tablespace bank_tbs datafile '/oradata/orcl/BANK.dbf' size 5M AUTOEXTEND ON MAXSIZE 10G;

/*创建用户*/
create user bankuser identified by bankpwd default tablespace bank_tbs;

/*对数据库用户授权*/
grant connect,resource to bankuser;


expdp
mkdir expdp_dir
chomd 777 expdp_dir

create or replace directory expdp_dir as '/home/oracle/expdp_dir';
grant read,write on directory  expdp_dir to bankuser; 


/*服务端工具 expdp impdp       win —— linux*/ 
源端：
sqlplus sys/xxx@ip/orcl as sysdba;
创建导出目录：create or replace directory expdp_dir as 'D:\xxxxx';
对用户授权：  GRANT WRITE,READ ON DIRECTORY expdp_dir TO xxggk;
数据备份：   expdp xxggk/BDCGGK@ip/orcl directory=expdp_dir dumpfile=xxggk.dmp logfile=xxggk.log;

目标端：
sqlplus / as sysdba;
创建导入目录：creat or replace directory impdp_dir as '/home/oracle/expdp ';
对用户授权：GRANT WRITE,READ ON DIRECTORY impdp_dir TO lfxxggk;
退出SQL
数据导入：impdp lfxxggk/lfxxggk@ip/orcl DIRECTORY=impdp_dir DUMPFILE=ZSGGK.DMP REMAP_SCHEMA=zsggk:lfxxggk REMAP_TABLESPACE=zsggk:lfxxggk