Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-38301: can not perform DDL/DML over objects in Recycle Bin

Re: ORA-38301: can not perform DDL/DML over objects in Recycle Bin

From: Terminator <kramakrishnabest_at_gmail.com>
Date: 9 Feb 2006 22:26:03 -0800
Message-ID: <1139552763.564791.284300@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

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US