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 grd?
what is logical system in sap basis
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
how does an oracle clusterware manage crs resources?
What would you do with an "in-doubt" distributed transaction?
Why would you use sql agent? : sql server DBA
how can you schedule a job in database?
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?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
what is a user-defined lock?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
