what is purge command
explain about oracle performance tuning

Answers were Sorted based on User's Feedback



what is purge command explain about oracle performance tuning..

Answer / apurva

Purge command is used to clear the recycle bin.
It can also be used with drop command
ex. drop table <tablename> purge;
this command will clear away the table from database as
well as from the recycle bin. After firing of purge command
you cannot retrive the table using flashback query.

Is This Answer Correct ?    37 Yes 3 No

what is purge command explain about oracle performance tuning..

Answer / pooja

Use the PURGE statement to remove a table or index from
your recycle bin and release all of the space associated
with the object, or to remove the entire recycle bin, or to
remove part of all of a dropped tablespace from the recycle
bin.
PURGE RECYCLEBIN;

Is This Answer Correct ?    24 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

What is cursor in pl sql with examples?

0 Answers  


can i create trigger on synonym is it possible or not please help me

4 Answers   CGI,


i have a table with column sno with 30 records. i want to update this column by item by item in asp.net. i wantto enter new values into that from 1 to 30 how is it possible with backend c#

1 Answers  


What is a native sql query?

0 Answers  


What does select count (*) mean in sql?

0 Answers  


What is auto increment in sql?

0 Answers  


What is assignment operator in pl sql?

0 Answers  


how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?

6 Answers  


What is a primary key? Explain

0 Answers  


what is ref cursor in pl/sql?

3 Answers  


how to use like conditions? : Sql dba

0 Answers  


How many types of sql are there?

0 Answers  


Categories