adspace


How to do a full database export?

Answer Posted / Efetyu

To perform a full database export in Oracle Database, you can use the Data Pump Export (DPEXP) utility. Run the command: DPEXP <username>/<password> FULL=Y SCHEMAS=(<schema_name>) DIRECTORY=<directory_name> CONTENT=DATA_ONLY; Replace <username>/<password> with your database credentials, <schema_name> with the name of the schema you want to export, and <directory_name> with the directory where you want to store the export files.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to write a left outer join with the where clause in oracle?

1151


What is oracle latest version?

1173


Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1955


How to put more than 1000 values into an oracle in clause?

1113


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

1156


Design database draw er diagram for a certain scenario ?

4654


How to start an oracle instance?

1103


How to select all columns of all rows from a table in oracle?

1130