How to use Oracle s IMP

impsystem/manager

file=bible_db

log=dible_db

full=y

ignore=y

System Manager is the username and password.

file=bible_db

is the file to be imported.

log=dible db is the name of the generated log.

full=y is to import the entire file.

ignore=y ignores the creation error.

The database is when I want to import, and the database is b

impsystem manager@ service sidfile=bible

log=dible_db

full=y

ignore=y

fromuser=a

touser=b

For detailed usage, you can enter cmd in "Run" to enter the command window and type.

imphelp=y'

Get help tips.

1. Open the PL SQL tool and select 'Import Table'.

2. Select the 'Oracle Import' function.

3. Select the file to be imported.

4. Click the 'Import' button to pop up the window of importing data.

5. After the import is successful, the import is complete.

6. View the imported data; select t.*,rowid from test_null t;You can find out that the table has been imported.

Solution 1: Oracle itself is implemented through the command line, and it comes with a SQL Plus tool; Every time you start Oracle, you can open its client and enter the corresponding user name, password and SID, and then you can log in to the operation interface and import and export in the form of commands;

Solution 3, this method, does not need any tools, directly enter something like imp tmrpt :1521 bocreport full= y file=c:

yucheng\event_log_ ignore= y;to directly import and export DMP files;

Oracle comes with the exp imp command, which can import and export data on the server side, but it needs to be transmitted to the client through FTP.

Other third-party client tools, such as ObjectBrowser, can perform exp imp operations directly in the GUI without transferring files to the server, which is easy to operate.

Yes, in the bin directory of Oracle Home, the import and export tool must be executed on the command line, not in PL SQL.