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!

exp rman ctalog 11g

wassim haddadOct 4 2015 — edited Oct 5 2015

Hello Dears

Oracle rel 11.2

i need to duplicate my rman catalog with exp and imp ,,

the problem is some table do not exported ... so the new catalog have many invalid objects

vpc_databases as an example

pleas look to command and the log

exp system/password file=/u01/CDs/rman.dmp STATISTICS=none owner=rman

Export: Release 11.2.0.1.0 - Production on Sun Oct 4 14:44:55 2015

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export done in US7ASCII character set and AL16UTF16 NCHAR character set

server uses WE8MSWIN1252 character set (possible charset conversion)

About to export specified users ...

. exporting pre-schema procedural objects and actions

. exporting foreign function library names for user RMAN

. exporting PUBLIC type synonyms

. exporting private type synonyms

. exporting object type definitions for user RMAN

About to export RMAN's objects ...

. exporting database links

. exporting sequence numbers

. exporting cluster definitions

. about to export RMAN's tables via Conventional Path ...

. . exporting table AL 482 rows exported

. . exporting table BCB 1 rows exported

. . exporting table BCF 4 rows exported

. . exporting table BDF 440 rows exported

. . exporting table BP 52 rows exported

. . exporting table BRL 681 rows exported

. . exporting table BS 58 rows exported

. . exporting table BSF 4 rows exported

. . exporting table CCF 0 rows exported

. . exporting table CDF 46 rows exported

. . exporting table CFS 209 rows exported

. . exporting table CKP 11 rows exported

. . exporting table CONF 14 rows exported

. . exporting table CONFIG 1 rows exported

. . exporting table DB 3 rows exported

. . exporting table DBINC 7 rows exported

. . exporting table DF 226 rows exported

. . exporting table FB 1 rows exported

. . exporting table NODE 3 rows exported

. . exporting table OFFR 3619 rows exported

. . exporting table ORL 32 rows exported

. . exporting table PDB 8 rows exported

. . exporting table PDBINC 8 rows exported

. . exporting table PDB_DBINC 12 rows exported

. . exporting table RCFILE 0 rows exported

. . exporting table RCVER 1 rows exported

. . exporting table RLH 33014 rows exported

. . exporting table ROUT 22817 rows exported

. . exporting table RSR 748 rows exported

. . exporting table RT 3 rows exported

. . exporting table SITE_DFATT 226 rows exported

. . exporting table SITE_TFATT 7 rows exported

. . exporting table TF 7 rows exported

. . exporting table TS 233 rows exported

. . exporting table TSATT 234 rows exported

. . exporting table XMLSTORE 0 rows exported

. exporting synonyms

. exporting views

. exporting stored procedures

. exporting operators

. exporting referential integrity constraints

. exporting triggers

. exporting indextypes

. exporting bitmap, functional and extensible indexes

. exporting posttables actions

. exporting materialized views

. exporting snapshot logs

. exporting job queues

. exporting refresh groups and children

. exporting dimensions

. exporting post-schema procedural objects and actions

. exporting statistics

Export terminated successfully without warnings.

any suggestion please

This post has been answered by Dude! on Oct 4 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 2 2015

Added on Oct 4 2015

#performance-availability, #recovery-manager-rman

5 comments

772 views