How to make a Data Backup in oracle ? What is the procedure
for creating the dump files in oracle ( any version ) ?
Answer Posted / ace dba
A dump is _NOT_ a backup. You cannot roll forward to a
point in time after the dump was taken. The dump is for
moving data from one environment to another, and etc. Using
dump for backup _WILL_ result in data loss.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the various oracle database objects?
What are the system predefined user roles?
Why do we need oracle client?
What is blob datatype?
What are the types of partitions in oracle?
Why is oracle used?
Explain table?
How to define a data source name (dsn) in odbc manager?
Will you be able to store pictures in the database?explain.
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What is the Tune Query
How to define an anonymous procedure without variables?
Can sub procedure/function be called recursively?
How to rebuild an index in oracle?
What are the differences between char and nchar in oracle?