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 can you find out if a table can be redefined?
what is the use of ocr?
What would you do with an "in-doubt" distributed transaction?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
how can you implement fine-grained auditing?
how can you create a user-defined lock?
what is the use of recording information about current session?
what is the role of dip user in our database?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
what functionality does oracle provide to secure sensitive information?
How do you open a cluster administrator? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
what is grd?