Interested to Buy Any Domain ? << Click Here >> for more details...
How to transfer database(500 gb) of oracle enterprise
edition to standard edition downtime is only 1 hour not
using exp/imp option ?
- 3 Answers
- 7620 Views
- Digital Group, I also Faced
- E-Mail Answers
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 usage of save points in oracle database?
What are the Characteristics of Data Files ?
10. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date.
What is difference between UNIQUE constraint and PRIMARY KEY constraint ?
What are the different windows events activated at runtime ?
What are the ways tablespaces can be managed and how do they differ?
How to start a new transaction in oracle?
List the types of joins used in writing subqueries?
What would you do if a database crashes in production?
Explain the use of control file?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
How to start your 10g xe server?
Oracle General 
