Topic: SQL*Plus and PL/SQL >> purge recyclebin?? error?
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: purge recyclebin?? error? |
| shantanu |
Posted: Mar 11, 2008 09:51:17 PM |
Total Post: 42
Joined: May, 2007
|
Hello guys
In the process of performing data refresh in acceptance from prod I used SQL> PURGE RECYCLEBIN; command which returned error something likeP2-0734: unknown command beginning "purge recy..." - rest of line ignored. Can anyone explain reason? also provide alternative solution to purge recycle bin.
Thanks in advance
Shanthan
|
|
|
 Gitesh |
| Posted: Mar 12, 2008 11:24:06 PM |  |
|
Total Post: 322
Joined: May, 2005
|
Hi,
Which of Oracle 10g version you are using.
In Oracle10g rel 2 there is a parameter called recyclebin default value is TRUE but if your dba made FALSE then there is no recyclebin utility will available in database. It is dynamic parameter you can alter with alter session or alter system command.
Check with following command.
alter session set recyclebin=true;
purge recyclebin;
In Oracle10g rel 1 this parameter was hidden _recyclebin=true.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 843 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 272 |
| neeraj sharma | 252 |
| Ramesh Jois | 245 |
| Bishal Khetan | 207 |
|
|
