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
How do you trace the traffic hitting a sql server? : sql server DBA
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
what are the types of connection load-balancing?
how can you initialize log miner?
how can you implement fine-grained auditing?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
Where do you find the default index fill factor and how to change it? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
How to start SQL Server in minimal configuration mode?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
how can you record information about current session?
. 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 can you get actual data change values from previous transactions in oracle?
How would you extract DDL of a table without using a GUI tool?
