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

Is sql a dbms?

0 Answers  


What is the reports view in oracle sql developer?

0 Answers  


wa procedure to return the month and the no'f developers joined in each month.

4 Answers   Fidelity,


HOW TO ADD PRIMARY KEY TO TABLE BY PL/SQL PROGRAM

3 Answers  


In testing where do we use sql language and how it helps in testing?

2 Answers  


Does it possible to pass object (or) table as an argument to a remote procedure?

1 Answers   TCS,


How do I view a sql trace file?

0 Answers  


What is left join example?

0 Answers  


select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

2 Answers  


What are the built in functions of sql?

0 Answers  


What is the use of & in pl sql?

0 Answers  


How much does a sql dba make? : SQL DBA

0 Answers  


Categories