Hi Abhijit,
Although the answer is a bit late, but I think that you will find it useful:
(1) Control_file_record_keep_time, is used in case you are using RMAN. Control file has two type of storage, first, non-reuable and second, reusable, the RMAN activities, such backup(s) are recorded in the reusable section. If the Control_file_record_keep_time is not set properly, may lead to uncontroled growth of control file.
(2) While a table is locked it can not be dropped as all the DDL commands are 'COMMIT WITH NO WAIT' statements.
Hope, this answers your query, for any further details feel free to mail me.
Regards,
Vibhor Agarwal
Executive - DBA
Mastek Ltd.
SEEPZ, Mumbai
Mob: +91-98195-35552
Email: [Email address protected]
----- Original Message -----
From: "Abhijit Dass " <oracledba-ezmlmshield-x25446913.[Email address protected]
Date: Mon, 21 Jun 2004 20:52:29 +0500 (IST)
To: "LazyDBA Discussion" <[Email address protected]
Subject: A couple of questions
Hi gurus,
I am relatively new to this forum and beginning to grow with oracle. Please help me with the following simple questions.
*** what is the relevance of the init.ora parameter CONTROL_FILE_RECORD_KEEP_TIME. Please give an example.
*** Can a table be dropped by the schema owner while certain rows are locked on account of updates by other users.
Thanx in advance.
-Abhijit.
-------------------------------------------------
Still single? Click here to find the perfect match.
http://www.bharatmatrimony.com/cgi-bin/bmclicks1.cgi?141
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: send a blank email to oracledba-[Email address protected]
By using this list you agree to these terms:http://www.lazydba.com/legal.html
--
India.com free e-mail - www.india.com.
Check out our value-added Premium features, such as an extra 20MB for mail storage, POP3, e-mail forwarding, and ads-free mailboxes!
Powered by Outblaze
Oracle LazyDBA home page