oracle导入、导出

创建表空间：

CREATE TABLESPACE TBSP_nnkk

DATAFILE 'E:\oracle\product\10.2.0\oradata\nnkk\nnkk1.dbf' size 500M

 autoextend off

 logging

 online

 permanent

 extent management local autoallocate

 blocksize 8k

 segment space management manual

 flashback on;

创建用户：

CREATE USER nnkk PROFILE "DEFAULT"

   IDENTIFIED BY nnkk DEFAULT TABLESPACE TBSP_nnkk

   TEMPORARY TABLESPACE temp

ACCOUNT UNLOCK;

--把DBA权限给用户   

GRANT DBA TO nnkk WITH ADMIN OPTION;

ALTER USER nnkk DEFAULT ROLE ALL;   

GRANT UNLIMITED TABLESPACE TO nnkk WITH ADMIN OPTION;