How do you resize a data file?
- 2 Answers
- 4304 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 |
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
What is Restricted Mode of Instance Startup in Oracle?
what is correlated subquery
My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.
Could you please let me know the interfaces in OM / FA??
What is Tax Categories?
What is the difference between conversions and interfaces? : oracle accounts receivable
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
0 Answers Punjab National Bank,
Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.
what is debit memo and credit memo in AR?
How to clone the database using RMAN back
Whats the purpose of using Nextval while creating the sequence.
Oracle General 
