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 are set operators?
What is a tns service name?
What is flashback Query ? And Use ?
What is ceil and floor in oracle?
Explain about achiever in sql?
Describe an oracle table?
Please explain the difference between outer join and inner join? With examples would be appreciable..!
How to use "startup" command to start default instance?
What are the general rules on data consistency?
How to select some columns from a table in oracle?
What is the function of Redo Log ?
How to use subqueries with the in operator using oracle?