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 / karthikeyan.r

>alter database (database Name)
datafile "location of datafile" resize 200m or 350 m;

Is This Answer Correct ?

2 Yes

0 No

How do you resize a data file?..

Answer / sampath

> alter database (database name) datafile (number)
resize 200m or 300m

Is This Answer Correct ?

1 Yes

0 No

More Oracle AllOther Interview Questions

I would like to study certification course in Data base adminidtrator then where would i go to study this course?

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

Where would you look for errors from the database engine?

default triggers available for reports

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

Difference between transaction type and transaction sources. : oracle accounts receivable

Can we get the deleted Record again if the delete transaction has been committed.

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

What is the use of lockboxes? : oracle accounts receivable

For more Oracle AllOther Interview Questions Click Here