How do you resize a data file?

Answer Posted / karthikeyan.r

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

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

735


Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

1842


What view would you use to determine free space in a tablespace?

1780


How would you go about increasing the buffer cache hit ratio?

1953


What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

756






What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

700


What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

685


What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?

1592


can u give guidance abt packages of plsql

1644


Give two methods you could use to determine what DDL changes have been made.

6021


1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

16354


Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

668


What is an Oracle database Partial Backup?

693


which one is currently in used software cmpanies.

1661


i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

1768