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 a directory object?

1101

How to load data from external tables to regular tables?

1063

What are the different pseudo commands? Explain in general?

1080

How to open and close an explicit cursor in oracle?

1058

How to drop a stored function?

1140

How to calculate date and time differences in oracle?

1044

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1739

What is a oracle database?

1061

what is port in oracle? how is it related to database application.

1950

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

1068

What is oracle database 10g express edition?

1123

How to divide query output into groups in oracle?

993

Describe the types of sub query?

1002

What are the differences between char and varchar2 in oracle?

1176

What are the ways tablespaces can be managed and how do they differ?

2373