ORA-38301: can not perform DDL/DML over objects in Recycle Bin
This is a discussion on ORA-38301: can not perform DDL/DML over objects in Recycle Bin within the Oracle Database forums, part of the Database Server Software category; --> Hi all, 1. The version of oracle is (Oracle 10g Release 2). 2. This error is given when the ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-25-2008, 03:12 AM
| ||||
| ||||
 ORA-38301: can not perform DDL/DML over objects in Recycle Bin Hi all, 1. The version of oracle is (Oracle 10g Release 2). 2. This error is given when the Informatica's repository being created. 3. The schema through which the repository is being created has dba rights. 4. I even saw the metalink, It gives no comments on Cause / Action, But it says that invalid FLASHBACK DROP OPTION. Regards, Terminator.      |
|
02-25-2008, 03:12 AM
| |||
| |||
| Re: ORA-38301: can not perform DDL/DML over objects in Recycle Bin "Terminator" <kramakrishnabest@gmail.com> a écrit dans le message de news: 1139548932.899798.55100@g47g2000cwa.googlegroups.c om... | Hi all, | | 1. The version of oracle is (Oracle 10g Release 2). | 2. This error is given when the Informatica's repository | being created. | 3. The schema through which the repository is being created | has dba rights. | 4. I even saw the metalink, It gives no comments on Cause / | Action, | But it says that invalid FLASHBACK DROP OPTION. | | | | Regards, | Terminator. | Before launching Informatica script, execute: alter session set recyclebin=off; Regards Michel Cadot |
|
02-25-2008, 03:12 AM
| |||
| |||
| Re: ORA-38301: can not perform DDL/DML over objects in Recycle Bin Michel Cadot wrote: > "Terminator" <kramakrishnabest@gmail.com> a écrit dans le message de news: 1139548932.899798.55100@g47g2000cwa.googlegroups.c om... > | Hi all, > | > | 1. The version of oracle is (Oracle 10g Release 2). > | 2. This error is given when the Informatica's repository > | being created. > | 3. The schema through which the repository is being created > | has dba rights. > | 4. I even saw the metalink, It gives no comments on Cause / > | Action, > | But it says that invalid FLASHBACK DROP OPTION. > | > | > | > | Regards, > | Terminator. > | > > Before launching Informatica script, execute: > alter session set recyclebin=off; > > Regards > Michel Cadot Thank you Sir, But it is a session lever. Can't we set it in the parameter level in the init.ora. Regards Terminator |
|
02-25-2008, 03:12 AM
| ||||
| ||||
| Re: ORA-38301: can not perform DDL/DML over objects in Recycle Bin "Terminator" <kramakrishnabest@gmail.com> a écrit dans le message de news: 1139552763.564791.284300@g47g2000cwa.googlegroups. com... | Michel Cadot wrote: | > "Terminator" <kramakrishnabest@gmail.com> a écrit dans le message de news: 1139548932.899798.55100@g47g2000cwa.googlegroups.c om... | > | Hi all, | > | | > | 1. The version of oracle is (Oracle 10g Release 2). | > | 2. This error is given when the Informatica's repository | > | being created. | > | 3. The schema through which the repository is being created | > | has dba rights. | > | 4. I even saw the metalink, It gives no comments on Cause / | > | Action, | > | But it says that invalid FLASHBACK DROP OPTION. | > | | > | | > | | > | Regards, | > | Terminator. | > | | > | > Before launching Informatica script, execute: | > alter session set recyclebin=off; | > | > Regards | > Michel Cadot | | Thank you Sir, But it is a session lever. Can't we set it in the | parameter level in the init.ora. | | Regards | Terminator As per your post, I thought you want it during repository creation. Else "alter system ... scope=both;" if you used spfile or directly "recyclebin=off" in init.ora. Regards Michel Cadot |
Linear Mode
