Oracle创建表空间和用户

1.创建表空间
create tablespace sso
logging
datafile 'C:oracledatasso.DBF'
size 512m
autoextend on
next 100m maxsize 20G
extent management local;

2.修改已有表空间大小
alter tablespace WEQS add datafile 'D:Oraclewqes01.dbf' size 200M autoextend on next 200m maxisize 20G

create tablespace gacfiat
logging
datafile 'D:APPADMINISTRATORORADATAORCLgacfiat.DBF'
size 512m
autoextend on
next 100m maxsize 20480m
extent management local;

4.创建用户并指定表空间
create user sso identified by sso
default tablespace sso;

5.给用户授予权限

grant connect,resource,dba to sso;

create or replace directory BACKUP as '/backup';
目录创建以后，就可以把读写权限授予特定用户，例如:
grant read, write on directory BACKUP to gacfiat;
此时用户eygle就拥有了对该目录的读写权限。

PORTALTS

GACFIAT

impdp gacfiat/gacfiat directory=BACKUP DUMPFILE=GACFIAT-expdp-20160729.dmp logfile=GACFIAT-impdp-20160729.log

impdp sso/sso directory=MYDUMP DUMPFILE=sso20190712.dmp logfile=imphhhsso.log
留下二个数据库

VSS

GACFIAT_TEST

排除表：

expdp vwls/vwlstest directory=BACKUP EXCLUDE=TABLE:"LIKE 'BMS_%'" DUMPFILE=exp222.dmp

指定导了表

[oracle@qfwb0402 ~]$ more vwls-exp-dms.sh
exp vwls/vwlstest GRANTS=Y TABLES=BMS_AREA,BMS_AREA_LIST,BMS_BANK_INFO,BMS_CARRI
ER_CAR, BMS_CARRIER_CARTYPE_INFO,BMS_CARRIER_LIST,BMS_CAR_LINE_RELATION , BMS_CA
R_TYPE ,BMS_COMPANY, BMS_COMPANY_SUB,BMS_DRIVER_INFO,BMS_FACTORY,BMS_INTERFACE_L
OG,BMS_LINE,BMS_LINE_CONFIG,BMS_LINE_NODE_RELATION BMS_NODE, BMS_NODE_RELATION,B
MS_SUMMARY,BMS_SUMMARY_SUB,BMS_SURPPLY_ATTACHER,BMS_SURPPLY_MANAGE,BMS_SURPPLY_T
OTAL, BMS_SYSTEM_ERROR_LOG, BMS_WORK_CALENDAR, BMS_WORK_TIMER,file=/tmp/dms20181
230.dmp

alter tablespace XXXXSPACE add datafile size 30G;