Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-38301: can not perform DDL/DML over objects in Recycle Bin
"Terminator" <kramakrishnabest_at_gmail.com> a écrit dans le message de news: 1139552763.564791.284300_at_g47g2000cwa.googlegroups.com...
| Michel Cadot wrote:
| > "Terminator" <kramakrishnabest_at_gmail.com> a écrit dans le message de news:
1139548932.899798.55100_at_g47g2000cwa.googlegroups.com...
| > | 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
|
|
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
Received on Fri Feb 10 2006 - 10:21:39 CST