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 is dbcc? : sql server DBA
what is the diffrence between core dba and apps dba?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
who owns the operating system files created by the utl_file package?
What happens on checkpoint? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
how to restore files with rman?
What are the different ways you can create databases in sql server? : sql server DBA
what is the use of ocr?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
