Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / suman
alter database tablespace ts1 add datafile
'/u01/oradata/directory name/ts1.dbf' size 5m autoextend on;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is fill factor? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
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
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is the difference between dropping a database and taking a database offline? : sql server DBA
Query processing is slow(eg select query)how will u solve that
What authentication modes does sql server support? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
what is grd?
What are the commands you'd issue to show the explain plan for "select * from dual"?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
who owns the operating system files created by the utl_file package?
how can you communicate with operating system files from oracle?
What is the difference between clustered and non-clustered index? : sql server DBA
