Sign Up Login


  1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

How do you resize a data file?

Question Posted / guest

Answers were Sorted based on User's Feedback



How do you resize a data file?..

Answer / guest

alter databse datafile 'location of datafile' resize 2000M



Regards
Abhinav Phadnis

Is This Answer Correct ?    13 Yes 3 No

How do you resize a data file?..

Answer / monal

in SQL Server 2005:

ALTER DATABASE <Database Name> MODIFY FILE
(NAME =<File Name>, MAXSIZE = <Size>)

Is This Answer Correct ?    9 Yes 8 No

Post New Answer

More DB Administration Interview Questions

Explain the use of table functions.

1 Answers  

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?

0 Answers  

Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?

11 Answers   FA, GE, Wipro,

1)how to Take Backup in sql server 2005 from Flash Drive

1 Answers  

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.

0 Answers  

how to restore files with rman?

0 Answers  

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

0 Answers  

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

0 Answers  

what is the role of dip user in our database?

0 Answers  

what do you understand by flashback feature of oracle?

0 Answers   Oracle,

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers   iGate,

What is a correlated sub-query? : sql server DBA

0 Answers  

For more DB Administration Interview Questions Click Here
Categories