Answer Posted / hemant shrimali (dba)
alter tablespace T1
add datafile 'c:\xx\T1.dbf' size 4M autoextend off;
| Is This Answer Correct ? | 8 Yes | 1 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?
what is a user-defined lock?
What is dbcc? : sql server DBA
how does an oracle clusterware manage crs resources?
how can you get actual data change values from previous transactions in oracle?
What authentication modes does sql server support? : sql server DBA
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
how can you initialize log miner?
What are the different sql server versions you have worked on? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
Query processing is slow(eg select query)how will u solve that
What purpose does the model database server? : sql server DBA
how can you find out if a table can be redefined?
