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

What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

Hi I am searching for best oracle Apps institute? Please tel me which is best institute in hyderabad I am working in developer 6i....

Could you please let me know the interfaces in OM / FA??

How do you create a credit note against an invoice? : oracle accounts receivable

what are the API of GL,PO,AP

What command would you use to create a backup control file?

Is there any link between pr form(purchse requisition)and po form(purchase order)

can we drop dual table

deference between & and &&

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

What do you mean by Oracle MEDIA RECOVERY?

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

For more Oracle AllOther Interview Questions Click Here