Answer Posted / sam
online patching,Tables can changed to read only,In datapump
parameter compression can have following values 1)
data_only,2)metadata_only,3)all,4)none
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How do you trace the traffic hitting a sql server? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
what is grd?
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?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What is a system database and what is a user database? : sql server DBA
Why would you use sql agent? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How would you best determine why your MVIEW couldn't FAST REFRESH?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
What are the recovery models for a database? : sql server DBA
how can you communicate with operating system files from oracle?