How to transfer database(500 gb) of oracle enterprise
edition to standard edition downtime is only 1 hour not
using exp/imp option ?
Answer Posted / 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 |
Post New Answer View All Answers
What is a sub query? Describe its types?
What does sharding mean?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How to run create database statement?
What is raw datatype in oracle?
What is the dynamic sql in oracle?
How many types of table in Oracle?
What is the parameter mode that can be passed to a procedure?
How remove data files before opening a database?
What is private procedure oracle?
In which language oracle has been developed?
how do u setup a replication site?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What happens to the data files if a tablespace is dropped?
Explain an exception?