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
Why would you call update statistics? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
what are the differences of where and if in SAS?
what is asm?
What is the importance of a recovery model? : sql server DBA
how can you create a user-defined lock?
What is the difference between clustered and non-clustered index? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is dbcc? : sql server DBA
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
How do you trace the traffic hitting a sql server? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
What are the different sql server versions you have worked on? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
What are the steps you will take to improve performance of a poor performing query?