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: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 10 Feb 2006 17:21:39 +0100
Message-ID: <43ecbd94$0$17056$626a54ce@news.free.fr>

"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

|

| 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 Received on Fri Feb 10 2006 - 10:21:39 CST

Original text of this message

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