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

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1418


How to export your own schema?

546


HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

1765


What is the difference between alert log file and tarce file ?

1616


How many types of cluster table in Oracle?

553






What is the data pump import utility?

564


Explain what are the characteristics of data files?

597


What is tns name?

519


What are privileges and grants?

546


How to unlock the sample user account in oracle?

537


How to revoke create session privilege from a user in oracle?

541


Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

911


What is the disadvantage of User defind function?

1809


How to assign a tablespace to a users in oracle?

568


How to get maxsal , minsal, ename department wise in single query

990