How to transfer database(500 gb) of oracle enterprise
edition to standard edition downtime is only 1 hour not
using exp/imp option ?
Answers were Sorted based on User's Feedback
Answer / snaukak
For Oracle 10g and higher you can try to use datapump.
It is much faster as runs on server only.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ron
use transportable tablespace
click on the link below for doing it with examples:
http://www.idevelopment.info/data/Oracle/DBA_tips/Tablespaces/TBS_5.shtml
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / pugal
You can import and export data with the "Schema Manager"
GUI that ships with Oracle Enterprise Manager (OEM).
| Is This Answer Correct ? | 0 Yes | 1 No |
what is the difference between oracle enterprise edition and oracle express edition?
What is a package in oracle?
What is Trigger in Oracle?
When does a Transaction end ?
What is difference between a formal and an actual parameter?
What is mean by Program Global Area (PGA) ?
what are different types of locks?
How do you store pictures in a database?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
When do you get a .pll extension in oracle? Explain its importance
What is Parallel Server ?
How to drop an index?