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
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 is a user-defined lock?
what are the types of connection load-balancing?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Where would you look for errors from the database engine?
What is dcl? : sql server DBA
How do you open a cluster administrator? : sql server DBA
how to restore files with rman?
What are the different types of indexes available in sql server? : sql server DBA
What is dbcc? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
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
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?