Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vinoth kumar
alter tablespace <tablespacename> add datafile 'u01
\oradata\db\test01.dbf' size 10m autoextend on next 5m
maxsize 50m
in prodution database autoextend off is to be avoid.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
what is the use of ocr?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What authentication modes does sql server support? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
Why would you call update statistics? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Where do you find the default index fill factor and how to change it? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
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?
Query processing is slow(eg select query)how will u solve that
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?
who owns the operating system files created by the utl_file package?
