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 high-availability solutions in sql server and differentiate them briefly? : sql server DBA
how can you enable flashback feature?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
how can you communicate with operating system files from oracle?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What authentication modes does sql server support? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What are the different types of indexes available in sql server? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
What happens on checkpoint? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
what is a user-defined lock?
how can you create a user-defined lock?
