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

default triggers available for reports

2001


as a technical developer in oracle applications which type errors feced in your experience sofar

2120


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?

995


Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

2626


what are the API of GL,PO,AP

2012


How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

1876


WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

1903


What is Restricted Mode of Instance Startup in Oracle?

938


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

1968


How would you determine what sessions are connected and what resources they are waiting for?

1866


Difference between negative and positive adjustments : oracle accounts receivable

845


Explain prerequisites and post activities of oracle database installation

1912


i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

2081


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

1051


What do you mean by Oracle MEDIA RECOVERY?

938