熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> SQL語言 >> 正文

如何使用Exp以傳輸表空間的方式將其導出[3]

2013-11-13 12:35:56  來源: SQL語言 

  開始exp

  SQL> host exp userid=\sys/change_on_install as sysdba\ transport_tablespace=y tablespaces=(hexiong) file=/u/app/oracle/exphexiongdmp
  Export: Release Production on ?????? ?? ::
  Copyright (c) Oracle Corporation All rights reserved
  Connected to: Oraclei Enterprise Edition Release Production
  With the Partitioning and Oracle Data Mining options
  JServer Release Production
  Export done in ZHSGBK character set and ALUTF NCHAR character set
  Note: table data (rows) will not be exported
  About to export transportable tablespace metadata
  For tablespace HEXIONG
   exporting cluster definitions
   exporting table definitions
   exporting table T
   exporting referential integrity constraints
   exporting triggers
   end transportable tablespace metadata export
  Export terminated successfully without warnings

[]  []  []  []  


From:http://tw.wingwit.com/Article/program/SQL/201311/16211.html
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.