answersLogoWhite

0


Best Answer

To export the entire database to a single file dba.dmp in the current directory.

- Login to server

exp SYSTEM/password FULL=y FILE=dba.dmp LOG=dba.log CONSISTENT=y

User Avatar

Wiki User

13y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you export database in oracle?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How do you load the data into oracle database to another database?

There are several different ways. If you are going between one Oracle database and another Oracle database you can create a database link. Another method would be an Oracle export to flat file and then a import to another database. This all depends on the type of database you are trying to load the data into.


The meaning of Oracle is?

Oracle is relational DataBase


What is the difference between oracle and oracle?

Oracle is one of the popular database and DBA (DataBase Administrator) is the person who maintain the database (install oracle software, create,setup,maintain database)


Is the relational database an example of oracle database?

A relational database is a type of database design. Oracle is a brand of database. You can create a relational database using Oracle. You can also create relational databases using other database applications.


What is the difference between oracle exadata and oracle database?

Differences: Oracle Database Appliance is not Exadata. Exadata is a pre-configured combination of hardware and software that provides an infrastructure solely for running Oracle Database. Oracle Database Appliance (ODA) is an integrated highly available (HA) database and applications system in a single box. To learn more about data science please visit- Learnbay.co


What type of database is Oracle?

Oracle is Relational database management System(RDBMS).


What is the difference between oracle and oracle erp?

Oracle is a database corporation that has many products such as Database, BI and ERP


IS Oracle a database program?

Includes Oracle NoSQL Database, Oracle Multitenant, Oracle Real Application Clusters, Oracle Partitioning, Oracle Advanced Compression, Oracle OLAP, Oracle Machine Learning, Spatial and Graph, Database Lifecycle Management Pack, Oracle Enterprise Manager Control, and more To learn more about data science please visit- Learnbay.co.


What is an oracle account?

Oracle is the name of a database, I would guess it is an account (username/password) on that database.


What is the differene between Oracle and database?

Oracle is a database. Oracle is a Relational Database Management System which is a specialized implementation of a database. It is designed to hold data that is related to one another and organized in the form of schemas and tables.


Oracle Database 11g is an example of which type of database?

multidimensional database


Which graphical DBA administration tool would be used to tune an oracle database?

oracle database configuration assistant.