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
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
what do you understand by flashback feature of oracle?
who owns the operating system files created by the utl_file package?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
how can you schedule a job in database?
what are the performance views in an oracle rac environment?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
what is a user-defined lock?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
How do you trace the traffic hitting a sql server? : sql server DBA
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?
