How to Import & Export Oracle Database

How to Import & Export Oracle Database
How to Import & Export Oracle Database

How to Import & Export Oracle Database ?

Download

Oracle_Import_Export-1

You will get this window

Oracle_Import_Export-2

Now we can able to import or export the database tables as we like

First we will see How to export the existing user tables in to the destination dmp file.

Query is

Exp username/password full=y file=c:\dump\suresh.dmp

Oracle_Import_Export-3

Oracle_Import_Export-4

Oracle_Import_Export-5

After completion the execution process , we will see the file i.e suresh.dmp in the specific path directory

Oracle_Import_Export-6

We got the final dump file from the user called Suresh.

We can import this dump file into the another user based on our requirement.

Now we will see How to import the dump file called suresh.dmp i.e available in the path called

C:\dump\suresh.dmp

 

Step – 1

Create the user .

Oracle_Import_Export-7

Start the SQL Run command for executing the queries

Oracle_Import_Export-8

First we have to connect oracle administrator for executing the queries

By default System is the oracle administrator.

Oracle_Import_Export-8 Oracle_Import_Export-9

Create the username called “sai”

Oracle_Import_Export-10

Oracle_Import_Export-11

User created successfully…

We have to Give the DBA permission to the user called sai.

We have ‘n’ no of permissions in dba in Oracle Database..

How to give full dba permission to the user called sai.

Query

Grant dba to sai;

Oracle_Import_Export-12

 

Now we can connect the user called sai.

Oracle_Import_Export-13

Now we will see any tables created in the user called sai..

Ofcourse just now only we create a user i.e sai , for testing purpose only we are trying….

We got the result called no rows selected..

I.e No tables are there…

Now we are going to import the dump file into this user

How to import suresh.dmp into the username called sai.

Oracle_Import_Export-14

Select the Start Database

We will get a window

Oracle_Import_Export-15

Now we have to enter the query for import

Query

Imp sai/sai full=y file=c:\dump\suresh.dmp;

Oracle_Import_Export-16

Download

Leave a Reply