一、信息查询

查询字符集

SELECT Userenv('language') FROM dual;

二、表空间、用户

查询表空间占用

select tablespace_name, sum(bytes)/1024/1024 from dba_data_files group by tablespace_name;

查询表空间文件路径

select name from v$datafile;

创建表空间

# PANG_HU :表空间名称
# '/data/oracle/oradata/orcl/PANG_HU.dbf' :表空间文件路径
# size 100m :初始容量
# autoextend on next 100m :自动增长，每次增加100m
create tablespace PANG_HU datafile '/data/oracle/oradata/orcl/PANG_HU.dbf' size 100m 
autoextend on next 100m;

创建用户并指定默认表空间

#
create user PANG_HU identified by "123456" default tablespace PANG_HU;

用户授权

grant connect,resource,dba to PANG_HU;

级联删除表空间、用户

DROP TABLESPACE PANG_HU INCLUDING CONTENTS AND DATAFILES;

drop user PANG_HU cascade;

三、导入导出

创建导入导出目录

# expdir ：目录名
create directory expdir as '/home/oracle';

给用户PANG_HU授权expdir目录

GRANT READ,WRITE ON DIRECTORY expdir to PANG_HU;

-----导入

impdp PANG_HU/123456@127.0.0.1:1521/orcl directory=expdir dumpfile=dbfile_01.dmp tablespaces=PANG_HU

-----导出

expdp PANG_HU/a123456 cluster=n schemas=PANG_HU dumpfile=dbfile_01.dmp logfile=expyth_asset.log directory=expdir