How to do a full database export?
- 1 Answers
- 1185 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is an Index Segment ?
How do I limit the number of rows returned by an oracle query after ordering?
Describe the types of sub query?
Why do we use coalesce function in oracle?
How to convert a string to a date in oracle database?
How to convert a date to char in oracle? Give one example.
Whether any commands are used for months calculation? If so, what are they?
how many triggers we can create on a table
11 Answers G2 Technology, TCS,
How do I connect to oracle database?
How to retrieve the count of updated rows?
What is the purpose of init.ora. ? how many init.ora exist in oracle installation? suppose there are 3 database on one oracle server, how many init.ora do I have? what are various database objects? how will you identify memmory related performace issue in oralce? any idea about basic architure difference of oracle and db2? comment on which is better , with reasons? what is a fuction based index? is it recommended to use the same. ? what is global temporay table? what is teh signification of the parameter session_cached_cursor ?
How to display the hierarchy of employee and managers without using connect by prior.
Oracle General 
