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
- 7628 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 |
hai, I am searching job on Oracle10g and PL/sql,Unix... can any one send me resume format. an suggest me how to prepare.. ann books..
How do I recompile a procedure in oracle?
What is the parameter mode that can be passed to a procedure?
How to create a testing table in oracle?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
what is the syntax of DELETE command?
Which is better Oracle or MS SQL? Why?
Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?
what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.
Oracle General 
