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
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What the different types of replication and why are they used? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is the default port no on which sql server listens? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What is the difference between dropping a database and taking a database offline? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
What is fill factor? : sql server DBA
What is dbcc? : 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 ?