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
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
what functionality does oracle provide to secure sensitive information?
how can you initialize log miner?
how can you communicate with operating system files from oracle?
what are the types of connection load-balancing?
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?
What are the different sql server versions you have worked on? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What are the commands used in dcl? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
What authentication modes does sql server support? : sql server DBA
how can a session indicate its interest in receiving alerts?
what is a crs resource?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?