How Can I Import Database in Oracle?

How can Export Database of Personal Library Software

Step1: Start Oracle Database 10g Express Edition->Start->All Program->Oracle Database 10g->Go to Database Home Page

 

Step 2: When Oracle Database 10g Express Edition open successfully, the following screen will shown:

Step 3: Your by default Oracle’s  Username is “system” and password that is entered by you at time of installation. In above figure password is “java”.

Step 4: Now you are login successfully, you can do something related your work.

Here we have create a new database,  we follow the following steps:

Step 4.1:Click on Administration Icon on Home

Step 4.2:Click on Database Users on HOME->ADMINSTRATION

Note: We have numbers of databases such as, ASTI, MYNEWDB, OLES,PLPL,PLS,PLSN.We have to create a new database user.

Step 4.3: Click on Create> button

Note: Fill the above entry for relating database, such as

                User name(means name of database that you want to create):pls(please give short name , because you will need to type again and again when you will work).

             Password: pls(something, but  small)

             User Privileges: DBA must be checked

             Click on Check All

            And finally click on Create button.

Your new database user create successfully.

Step 4.4. Now you can login own new database. Now, logout from system database and login own username : MyNewDB and  password: mynewdb

IMPORT DATABASE OF THIS PROJECT

We follow the following the steps:

Step1: Open SQL Command promp

Step2: The following figure will shown:

Stpe3: Type connect command for connecting MyNewDB, will ask username:MyNewDB and password:1234/mynewdb type.

Note: If username and password are correct then the following figure will open.

Step 4: Open new dos command prompt using cmd in search box.

Step 5: You have downloaded my project folder and keep in any drive such as, D,E, so many. Switch a particular driver where my databse backup file stores.

D:\Mini Project\Database Backup>imp pls/pls tables=REGISTERFRIEND,REGISTERB

OOK file=Personal_Library_Backup.dmp

Warning: Database Name: pls and password: pls for this project.
If you face any problem in this project write error and their print screen send on my email id:                                              nishichandra7@gmail.com
Thanks.

                                 

Share on Facebook Share on Twitter Share on Google Plus

About Unknown

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.