If you're unsure in which script a sys or system-owned
object is created, but you know it's in a script from a
specific directory, what UNIX command from that directory
structure can you run to find your answer?
Answer Posted / qwerty
grep -i object *
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
how can you record information about current session?
How would you go about verifying the network name that the local_listener is currently using?
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?
How can you control the amount of free space in your index pages? : sql server DBA
. 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?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
how can you get actual data change values from previous transactions in oracle?
What are the different ways you can create databases in sql server? : sql server DBA
What purpose does the model database server? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
What is replication? : sql server DBA
how to restore files with rman?
How do you open a cluster administrator? : sql server DBA
What is dcl? : sql server DBA