Interested to Buy Any Domain ? << Click Here >> for more details...
what is purge command
explain about oracle performance tuning
- 2 Answers
- 26568 Views
- Accenture, eCentric Solutions, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
What is t-sql? : Transact sql
what is self join and what is the requirement of self join? : Sql dba
What are the disadvantages of not performing database normalization?
What is autocommit sql?
How to select 10 records from a table?
explain access control lists. : Sql dba
what does myisamchk do? : Sql dba
How to come back in normal stage in Mutating Table if mutating table is locked or update data?
Is it possible to link two groups inside a cross products after the cross products group has been created?
What is a pdo connection?
Can you sum a count in sql?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
