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
How to start SQL Server in minimal configuration mode?
What is a system database and what is a user database? : sql server DBA
Why would you call update statistics? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
how can a session indicate its interest in receiving alerts?
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.
what are the benefits of flashback feature?
What are the recovery models for a database? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
what do you understand by fine-grained auditing?
What are statistics, under what circumstances they go out of date, how do you update them?
what are the differences of where and if in SAS?
Explain about your sql server dba experience? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
