-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|