Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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 ?

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


Please Help Members By Posting Answers For Below Questions

What is a sub query? Describe its types?

965


What does sharding mean?

950


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?

1864


How to run create database statement?

979


What is raw datatype in oracle?

1052


What is the dynamic sql in oracle?

1010


How many types of table in Oracle?

1065


What is the parameter mode that can be passed to a procedure?

983


How remove data files before opening a database?

1000


What is private procedure oracle?

958


In which language oracle has been developed?

1020


how do u setup a replication site?

1927


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2080


What happens to the data files if a tablespace is dropped?

996


Explain an exception?

925