How do you resize a data file?

Answer Posted / sampath

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

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

1820


Differentiate between transaction type and transaction source? : oracle accounts receivable

678


Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1234


What is Tax Categories?

1624


What are different types of receipt reversals ? Explain them : oracle accounts receivable

720






What is the use of lockboxes? Steps for lock box : oracle accounts receivable

723


What is the use of lockboxes? : oracle accounts receivable

653


What is autocashrule set? : oracle accounts receivable

733


Explain the payment term in ar. : oracle accounts receivable

615


What is Restricted Mode of Instance Startup in Oracle?

673


Explain accounting for invoice in advance and arrears. : oracle accounts receivable

615


1. What is PO rate variance gain and loss?

2312


Why more redos are generated when the oracle database is in begin backup mode?

660


Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

6736


PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

1700