what is the difference between catalog & nocatalog?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / manish
catalog means backup information store in control file as well as catalog database.
nocatalog means backup information store in only control file no other external repository
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / mohammed rafi uddin
Catalogue means backup contains the information of control file, backup information and tendency of time period and requires no network connectivity.whereas no catalogue having separate database backup information, no limit of time period & It should be network wise connection.
| Is This Answer Correct ? | 1 Yes | 1 No |
why we use cursors
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
what is the use of recording information about current session?
An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?
what is incremental checkpoint?
what is the difference between off-line back up and on-line back up in ibm db2 udb?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Why would you use sql agent? : sql server DBA
why Datapump is faster than traditional export and import
how can a session indicate its interest in receiving alerts?
CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva
What is the difference between the SQL Loader and IMPORT utilities?
Oracle (3253)
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)