Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

export IOT tables

999373Apr 2 2013 — edited Apr 3 2013

Hello Experts,

i am migrating database from one server to another server. i am using export and import. while exporting the database
somehow, oracle is skipping few tables, specially IOT tables under a schema called SDE. i am trying to do expdp/exp
as schema owner, as well as sys user.

i have tried to export a single IOT table and i am getting table or view doesn't exist.

i have verfied,deferred_segment_creation and it was set to false. all objects got allocated extents. still i did see the error.

could you please advice how to export IOT tables.
also i have a another question,
do i need to follow any special procedure to export spatial/srdi application schema?

here is the error message i am getting :

Export terminated successfully with warnings.
PREPROD sidspre4db3: /home/oracle # exp sde/pwd file=/dbbackup/sde_exp/sde_tab_s11idx.dmp log=sde_s11idx.log tables="SDE.S11_IDX$"

Export: Release 11.2.0.1.0 - Production on Tue Apr 2 13:27:22 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Tes
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)

About to export specified tables via Conventional Path ...
EXP-00011: SDE.S11_IDX$ does not exist
Export terminated successfully with warnings.