/*创建临时表空间 */

create temporary tablespace jgszz_temp

tempfile 'D:\oradata\jgszz\temp.dbf'

size 20480M

autoextend on

next 500M maxsize 30720M

extent management local;  

/*创建表空间 */

create tablespace jgszz_data

nologging

datafile 'D:\oradata\jgszz\data.dbf'

size 4096M

autoextend on

next 200M maxsize 20480m

extent management local;

/*创建用户并赋予权限和表空间 */

create user shfcdqms identified by shfcdqms

default tablespace jgszz_data

temporary tablespace jgszz_temp;

grant connect,resource,dba to shfcdqms;

grant create session,create table,unlimited tablespace to shfcdqms;

/*导出和导入的方法 */

exp zy/zy@orcl file=c:\daochu.dmp tables=(B2B_ContNo)

exp b2b/U123$@ML-B2B-sitNew file=d:\zct.dmp tables=(b2b_intf_zctnpf)

exp b2b/U123$ file=D:/b2blcpol.dmp  tables=b2b_lcpol,b2b_intf_lcpol  

exp nfc_card/nfc_card@192.168.3.211:1521/orcl file=D:/nfc_card20140609.dmp

imp b2b/b2b@ORCL file =c:\2.dmp full=y ignore=y

imp b2b/b2b@ORCL  flie=c:\b2b_data.dmp fromuser=zy touser=b2b 

/*查看一共有多少个表空间 */

select tablespace_name from dba_tablespaces;