expdp及exp

oracle$mkdir liang
SQL>create directory liang as '/oracle/liang';

SQL>grant read,write on directory liang to public;
expdp system/kingdee directory=liang dumpfile=ysesbtmp20100222.dmp logfile=liang.log schemas=ysesbtmp
impdp system/kingdee directory=liang dumpfile=ysesbtmp20100222.dmp logfile=liang.log REMAP_SCHEMA=ysesbtmp:ecdecbiz REMAP_TABLESPACE=ysesbtmp:ecdecbiz_tab

exp

导出scott用户
exp scott/kingdee file=scott01.dmp log=scott01.log
注意:导出的还是scott用户,只不过是用system用户导
exp system/kingdee file=scott01.dmp log=scott01.log

导出scott和hr用户用owner
exp system/kingdee wner=(scott,hr) file=scott_hr.dmp log=scott_hr.log

导出emp表字段DEPTNO>20的记录
exp scott/kingdee tables=(emp)query="'where DEPTNO>20'" file=scott_emp.dmp log=scott_emp.log

导出整库
exp system/kingdee file=all_full.dmp log=all_full.log full=y

set long 999999
SQL> SELECT DBMS_METADATA.GET_DDL('TABLE','EMP') FROM DUAL;  可用查看出建emp表语句

DBMS_METADATA.GET_DDL('TABLE','EMP')
--------------------------------------------------------------------------------

  CREATE TABLE "SCOTT"."EMP"
   (    "EMPNO" NUMBER(4,0),
        "ENAME" VARCHAR2(10),

查看当前用户所属对象占用空间
SQL> SELECT SUM(BYTES)/1024/1024 M FROM user_segments;

         M
----------
      .375
如果对象来自多个用户
SQL> SELECT OWNER,SUM(BYTES)/1024/1024/1024 G
  2  FROM dba_segments
  3  WHERE OWNER IN('SCOTT','HR','STORE')
  4  GROUP BY OWNER
  5  ORDER BY 2 DESC;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15119715/viewspace-677121/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15119715/viewspace-677121/