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
Can you redefine a table online?
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?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
how can you enable flashback feature?
What are the commands used in dcl? : sql server DBA
how can you initialize log miner?
What are the operating modes in which database mirroring runs? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
what is the use of ocr?
What is the default fill factor value? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What are the different ways you can create databases in sql server? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
