No question at this time
DBA Top 10
1 A. Kavsek 12200
2 M. Cadot 7000
3 P. Wisse 5600
4 B. Vroman 5400
5 J. PĂ©ran 1900
6 . Lauri 1500
7 T. P 500
7 R. Pattyn 500
9 T. Boles 400
10 A. Chavan 300
10 J. Schnackenberg 300
10 D. Johnson 300
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48454
Total active users1499
Act. users last 24h5
Act. users last hour0
Registered user hits last week216
Registered user hits last month950
Go up

recreate pdb
Next thread: system trigger failed
Prev thread: Minimal memory pool values

Message Score Author Date
Hi Guys I have a pdb database that I should rec...... Tso P Sep 13, 2019, 10:27
Hi Tso, can you: - create "problematic" part...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Ales Kavsek Sep 13, 2019, 11:16

Follow up by mail Click here


Subject: recreate pdb
Author: Tso P, South Africa
Date: Sep 13, 2019, 10:27, 67 days ago
Os info: solaris 11
Oracle info: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Message: Hi Guys

I have a pdb database that I should recreate due to the dictionary objects being corrupt.

To be specific it is the index i_obj$ on the table OBJ$, which are the data dictionary objects and that cannot be recreated at the CDB or PDB level.

Now, I have tried to export the application data using data pump but I get the same error:

Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
ORA-31626: job does not exist
ORA-31633: unable to create master table "SYSTEM.SYS_EXPORT_SCHEMA_08"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1161
ORA-08102: index key not found, obj# 169685, file 8, block 68023 (2)
ORA-06512: at "SYS.KUPV$FT", line 1054
ORA-06512: at "SYS.KUPV$FT", line 1042

I have tried the traditional/classic exp but there are tables that I cannot exp due to the error EXP-00107 and EXP-00113.

This is mainly due to the fact that they are the composite partitioning and system partitioning objects as such the classic exp don't support their export.

How can I recreate these 30 failing objects?

Please help !!!

Thanks in advance !!!

Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: recreate pdb
Author: Ales Kavsek, Slovenia
Date: Sep 13, 2019, 11:16, 67 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Hi Tso,

can you:

- create "problematic" partitioned tables on your new PDB
- create dblink from new PDB to corrupted PDB
- copy data to newly created partitioned table on new PDB with insert into ... select ... from xx@dblink

Regards,
Ales
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here