For Oracle 10g and higher you can try to use datapump. It is much faster a

How to transfer database(500 gb) of oracle enterprise
edition to standard edition downtime is only 1 hour not
using exp/imp option ?

Question Posted / snaukak

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

Please Help Members By Posting Answers For Below Questions

What is raw datatype in oracle?

590

Why does for update in oracle 8 cause an ora-01002 error?

558

Explain view?

588

Â How to use an oracle sequence generator in a mapping?

573

How to use subqueries with the exists operator in oracle?

612

How to define an explicit cursor in oracle?

609

Explain what does a control file contain?

619

What are the different editions of oracle?

601

Explain the features of oracle?

606

How to divide query output into groups in oracle?

567

What is bind variable in oracle 11g?

598

Explain a data segment?

660

How to retrieve data from an cursor to a record?

567

How to login to the server without an instance?

628

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

4287