Interested to Buy Any Domain ? << Click Here >> for more details...
How do you resize a data file?
- 2 Answers
- 5427 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / karthikeyan.r
>alter database (database Name)
datafile "location of datafile" resize 200m or 350 m;
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sampath
> alter database (database name) datafile (number)
resize 200m or 300m
| Is This Answer Correct ? | 1 Yes | 0 No |
Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?
What is the difference between recovery and restoring of the oracle database?
Give the stages of instance startup to a usable state where normal users may access it.
How to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views
what are important reports in HRMS,GL,AP,AR in oracle apps?
3 Answers IBM, Pathway Technologies, Satyam, Techtimer, Wipro,
What view would you use to determine free space in a tablespace?
How would you determine who has added a row to a table?
What is the Query Optimizer. How you optimize your qeury.
where the dff data will be stored
Give the reasoning behind using an index.
What is $FLEX$ and $PROFILES$?
What is the difference between oracle media recovery and crash recovery?
Oracle General 
