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
- 7469 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 |
How are extents allocated to a segment?
How to turn on or off recycle bin for the instance?
Can we convert a date to char in oracle and if so, what would be the syntax?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
What is catalog in Oracle?
how to retrieve 1st and last row of table without using group functions??
What is merge statement used for?
what is the difference between data migration and production migration.
Differentiate between pre-select and pre-query?
What is tns service name?
Does rowid change in oracle?
Oracle General 
