How do you resize a data file?
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 |
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
wht r the base tables & primary key for BOM& WIP modules
why r u using etl tool.
Explain the difference between a hot backup and a cold backup and the benefits associated with each
Explain an ORA-01555
Name three advisory statistics you can collect.
What is the Query Optimizer. How you optimize your qeury.
What is chargeback invoice? How do we create it? : oracle accounts receivable
how can it possibble to see the report output in excel sheet in oracle applications
Is it possible to drop a column in a table which contains only one column? How?
can we use lexical perameter in oracle plsql if yes how
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.