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 are the different sql server versions you have worked on? : sql server DBA
what is the use of recording information about current session?
what do you understand by fine-grained auditing?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What is a correlated sub-query? : sql server DBA
how can you communicate with operating system files from oracle?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What is the importance of a recovery model? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
what are the types of connection load-balancing?
what is the role of dip user in our database?
What is the default fill factor value? : sql server DBA
