Answer Posted / guest
alter databse datafile 'location of datafile' resize 2000M
Regards
Abhinav Phadnis
| Is This Answer Correct ? | 13 Yes | 3 No |
Post New Answer View All Answers
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
Explain about your sql server dba experience? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
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
how can you implement fine-grained auditing?
what are the types of connection load-balancing?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Which autogrowth database setting is good? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
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.
What the different components in replication and what is their use? : sql server DBA
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
when does an alert gets signaled?