Home » RDBMS Server » Server Utilities » ORA-39151 (oracle 10.2.0.3 on Solaris 10)
ORA-39151 [message #365349] Thu, 11 December 2008 11:34 Go to next message
Lucky A
Messages: 65
Registered: October 2007
Member
Hi,

Recently some LOB data was moved to another tablespace and I want to downsize the tablespace it occupied.
This is what I did:
1. Exported the tablespace using datapump.
2. Renamed the old tablespace.
3. Created a new tablespace with the same name as the original before it was renamed.
4. Granted unlimited quota to the user/owner of the objects in the tablespace.
5. Imported the tablespace using datapump.

I am experiencing ORA-39151 on many of the objects:
ORA-39151: Table "MAYTREE"."LC_AIR_SCENE" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/AUDIT_OBJ
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/TRIGGER
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

How can I resolve this?


Thanks,

Lucky
Re: ORA-39151 [message #365355 is a reply to message #365349] Thu, 11 December 2008 12:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Drop the table before import.

Regards
Michel
Re: ORA-39151 [message #365365 is a reply to message #365349] Thu, 11 December 2008 13:49 Go to previous message
Lucky A
Messages: 65
Registered: October 2007
Member
Thanks Michel.

I added to my command: TABLE_EXISTS_ACTION=REPLACE
which took care of my problem.

The full command:

impdp username/password@db1 TABLESPACES=tablespace_name DIRECTORY=datapump DUMPFILE= tbser.dmp LOGFILE=tbser.log TABLE_EXISTS_ACTION=replace


Lucky
Previous Topic: IMP-00010: not a valid export file, header failed verification
Next Topic: sql loader
Goto Forum:
  


Current Time: Wed Dec 07 18:22:54 CST 2016

Total time taken to generate the page: 0.14082 seconds