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
What are the operating modes in which database mirroring runs? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
How do you trace the traffic hitting a sql server? : sql server DBA
What purpose does the model database server? : sql server DBA
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
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
What are the different types of indexes available in sql server? : 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?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what do you understand by flashback feature of oracle?
What is the default port no on which sql server listens? : sql server DBA
What is dcl? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
What is dbcc? : sql server DBA
