Answer Posted / hemant shrimali (dba)
alter tablespace T1
add datafile 'c:\xx\T1.dbf' size 4M autoextend off;
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
what are the differences of where and if in SAS?
Why would you use sql agent? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
what is a user-defined lock?
what is grd?
What is replication? : sql server DBA
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
which background process invoke at the time of upgradation tell me???
when does an alert gets signaled?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
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.
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Query processing is slow(eg select query)how will u solve that