Export Tablespaces
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Export Tablespaces

  1. #1
    Join Date
    Dec 2001
    Posts
    337

    Export Tablespaces

    Hi all,

    I am running 10.2.0.1 on Windows 2003. I wanted to test out exporting tablespaces. I used this syntax:

    exp username/pass tablespaces=(tbs1) file=test.dump.

    This worked however it did not export all the tables (probably because the two tables are owned by SYS) in the tablespaces and none of the indexes. Is there a reason for this?

    SEGMENT_NAME SEGMENT_TYPE
    ----------------------------------
    DEPT TABLE
    PK_DEPT INDEX
    EMP TABLE
    PK_EMP INDEX
    BONUS TABLE
    SALGRADE TABLE
    NIK TABLE
    REPAIR_TABLE TABLE
    ORPHAN_TABLE TABLE
    TESTAS TABLE

    C:\Oracle_Test>exp system/***** tablespaces=(users) indexes=y file=tbs.dmp

    Export: Release 10.2.0.1.0 - Production on Fri Jun 1 18:16:10 2007

    Copyright (c) 1982, 2005, Oracle. All rights reserved.


    Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Produc
    tion
    With the OLAP and Data Mining options
    Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

    About to export selected tablespaces ...
    For tablespace USERS ...
    . exporting cluster definitions
    . exporting table definitions
    . . exporting table NIK 46659 rows exported
    . . exporting table TESTAS 46510 rows exported
    . . exporting table BONUS 0 rows exported
    . . exporting table DEPT 4 rows exported
    . . exporting table EMP 14 rows exported
    . . exporting table SALGRADE 5 rows exported
    . exporting referential integrity constraints
    . exporting triggers
    Export terminated successfully without warnings.

    Any advice on this will be highly appreciated
    Thanks in advance,
    Chucks

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    sys objects are never exported - index ddl is done with the tables unless they are in a different tablespace

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width