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
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
Thank you Sir, But it is a session lever. Can't we set it in the parameter level in the init.ora.
Regards
Terminator
Received on Fri Feb 10 2006 - 00:26:03 CST