| SURESH |
Posted: Jan 09, 2007 09:23:07 AM |
Total Post: 10
Joined: Jan, 2007
|
When we try to drop a table it says
Failed to execute: DROP TABLE PARTY_ACCOUNT_ROLE_ARCHIVE
[sql] java.sql.SQLException: ORA-38301: can not perform DDL/DML over objects in Recycle Bin
for ex
drop table test
And when we try to create it again assuming it is dropped
then it says
create table test
At the time of table creation we got a error
Failed to execute: DROP TABLE PARTY_ACCOUNT_ROLE_ARCHIVE
[sql] java.sql.SQLException: ORA-38301: can not perform DDL/DML over objects in Recycle Bin
And when we try to create it again assuming it is dropped
then it says
Table / View allready exists.
plz help me
Thanks
suresh kumar
mail_suresh_dba@yahoo.co.in
|
|
|
 SatyaN |
| Posted: Jan 09, 2007 01:44:53 PM |  |
|
Total Post: 28
Joined: Nov, 2006
|
Try to purge recycle bin and try .
PURGE dba_recyclebin;
|
|
|
|
|
| SURESH |
| Posted: Jan 10, 2007 01:15:11 AM | |
|
Total Post: 10
Joined: Jan, 2007
|
Thanku u satya
but i am unabel to purge the dba_recyclebin it is production server it has may schemas(users) running on that database.
is their any other alternative solution for that ?
Thanks
Suresh Kumar
mail_suresh_dba@yahoo.co.in
|
|
|
|
|
| goethe |
| Posted: Jan 14, 2007 11:48:41 AM | |
|
Total Post: 5
Joined: Jan, 2007
|
Of course. Simply log into the database as the owner of the table that you dropped and issue
purge user_recyclebin;
You can purge either an individual user or the entire database's recyclebin
Cheer
Goethe
|
|
|
|
|
| babachild |
| Posted: Feb 18, 2007 01:24:20 AM | |
|
Total Post: 2
Joined: Feb, 2007
|
try using
FLASHBACK TABLE TABLE_NAME;
COMMIT;
DROP TABLE TABLE_NAME;
Hi friends. If anybody can send me some OCP 1,2,3,4 exam questions dumps i will be grateful
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
