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 |
How to use "for" statements in oracle?
What is a private synonym?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
Use of an integrity constraint is better to validate data. Explain
what are pseudocolumns?
what are the default admin accounts in Oracle 10g ?
What is an UTL_FILE.What are different procedures and functions associated with it?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
what is the difference between first normal form & second normal form?
How to work with data objects interactively?
What is the minimum client footprint required to connect c# to an oracle database?
How to call a trigger inside a stored procedure?Give an example.