How do you resize a data file?

Question Posted / guest

2 Answers
13945 Views
I also Faced
E-Mail Answers

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

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers

What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers

How do you switch from an init.ora file to a spfile?

4 Answers TCS,

What is the recommended interval at which to run statspack snapshots, and why?

1 Answers

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.

0 Answers

What does coalescing a tablespace do?

1 Answers

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

4 Answers

How would you begin to troubleshoot an ORA-3113 error?

1 Answers

Name three advisory statistics you can collect.

1 Answers

What is fill factor? : sql server DBA

0 Answers

what do you understand by flashback feature of oracle?

0 Answers Oracle,

For more DB Administration Interview Questions Click Here