what is the difference between catalog & nocatalog?
Answer Posted / kittu_chintu2005
CATALOG is used when you use a repository database as catalog.
NOCATALOG is used when you used the controlfile to register your backup information.
Default in NOCATALOG.
Is This Answer Correct ? | 44 Yes | 3 No |
Post New Answer View All Answers
Explain materialized views and how they are used.
Why does Oracle not permit the use of PCTUSED with indexes?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
what is asm?
What are the commands you'd issue to show the explain plan for "select * from dual"?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
internal architecture
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How would you go about verifying the network name that the local_listener is currently using?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
What are the different sql server versions you have worked on? : sql server DBA
what is logical system in sap basis
how can you find out if a table can be redefined?
how can you implement fine-grained auditing?