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 |
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
What is oracle thin client?
what is Single Byte Overhead...?
What is recycle bin in Oracle?
Describe Referential Integrity ?
What are the built-in functions used for sending Parameters to forms ?
What is the maximum limit on the number of columns in a table?
Is oracle a relational database?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How to drop an existing table in oracle?
What is Hash Cluster ?
Can objects of the same Schema reside in different tablespaces.?