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 the difference between translate and replace in oracle?

648

How to join two tables in a single query using oracle?

564

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.

4257

What is pragma autonomous transaction in oracle?

516

What is backup in Oracle?

567

What is the sql query to concatenate column values from multiple rows in oracle?

559

What is a sub query? Describe its types?

542

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

608

How many categories of data types?

570

What is meant by joins? List out the types of joins.

524

How to test null values?

673

What is the relation of a user account and a schema?

611

What privilege is needed for a user to create views in oracle?

587

What are the different types of synonyms?

592

How to resolve name conflicts between variables and columns?

566