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 / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is merge in oracle?

550


How to invoke the data pump import utility?

639


How to create a new table by selecting rows from another table?

542


What is merge statement used for?

558


Explain an index?

654






How does the on-delete-cascade statement work?

597


How to define a variable to match a table column data type?

572


Why we use bulk collect in oracle?

526


How to use values from other tables in update statements using oracle?

557


How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

534


Hi Can any one tell me what are the API's used in requisition import.

1474


What are the different oracle database objects?

576


From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

579


Explain the use of record length option in exp command.

546


What are triggers in oracle?

549