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?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
what is ora 24313?what is the procedure to exclude that error?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
internal architecture
Query processing is slow(eg select query)how will u solve that
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
what is the role of dip user in our database?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
how to restore files with rman?
what is the diffrence between core dba and apps dba?
how can you connect from 10g user to 11g user??
which background process invoke at the time of upgradation tell me???
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
