Oracle imp command description

2010-06-11  来源:本站原创  分类:Database  人气:186 

Oracle's Import utility (Import utility) allows to extract data from the database and write data to the operating system files. imp to use the basic format: imp [username [/ password [@ service]]], the following enumerated imp common usage.

1. Get Help

imp help=y

2. Import a full database

imp system/manager file=bible_db log=dible_db full=y ignore=y

3. Into a specified user or group belongs to all the tables, indexes and other objects

imp system/manager file=seapark log=seapark fromuser=seapark imp  system/manager file=seapark log=seapark fromuser=(seapark,amy,amyc,harold)

4. The data into a user belongs to another user

imp system/manager file=tank log=tank fromuser=seapark touser=seapark_copy imp system/manager file=tank log=tank fromuser=(seapark,amy) touser=(seapark1, amy1)

5. Into a table

imp system/manager file=tank log=tank fromuser=seapark TABLES=(a,b)

6. Importing from multiple files

imp system/manager file=(paycheck_1,paycheck_2,paycheck_3,paycheck_4) log=paycheck, filesize=1G full=y

7. Using the parameter file

imp system/manager parfile=bible_tables.parbible_tables.par

Parameter file:
# Import the sample tables used for the Oracle8i Database Administrator's Bible. Fromuser = seapark touser = seapark_copy file = seapark log = seapark_import

8. Incremental import

imp system./manager inctype= RECTORE FULL=Y FILE=A
相关文章
  • Oracle imp command description 2010-06-11

    Oracle's Import utility (Import utility) allows to extract data from the database and write data to the operating system files. imp to use the basic format: imp [username [/ password [@ service]]], the following enumerated imp common usage. 1. Get He

  • Detailed oracle IMP command (turn) 2011-03-17

    Oracle's import utility (Import utility) allows to extract data from the database, and write data to the operating system files. imp with the basic format: imp [username [/ password [@ service]]], the following examples of common usage imp. 1 Getting

  • Detailed in oracle imp command (turn) 2011-08-30

    Oracle's import utility (Import utility) allows to extract data from the database and operating system to write data to the text Pieces. The basic format for using imp: imp [username [/ password [@ service]]], the following examples of common usage i

  • Oracle imp command to import the data into the specified table space 2011-05-01

    Find a library of several million rows of data, ready to import in the local Oracle: imp sam / lee file = D: \ agent.dmp FROMUSER = system TOUSER = SAM SAM user's default table space is SAM, but the data into the system table space. Google a bit, you

  • oracle imp command to import 2011-02-22

    This easy to record. Original: http://www.bokee.net/bloggermodule/blog_viewblog.do?id=465310 1 Getting Help imp help=y 2 into a complete database imp system/manager file=bible_db log=dible_db full=y ignore=y 3. Import a specified user or group belong

  • oracle imp to import data in Chinese garbled default classification. 2011-03-16

    oracle imp to import data in Chinese garbled default classification. Today, with the forgotten oracle imp command to import data, check out the Chinese all fields are garbled (sqlplus, plsql dev, powerbuilder), online search for a long time, I found

  • Oracle exp command on the imp and illustrate the use of 2010-04-26

    Oracle commands on the use of imp and exp (Lsnrctl stop (stop service) lsnrctl start (Start Service)) 1. Exp orcl/orcl123 @ thost file = c: \ db.dmp 2. Imp orcl/orcl123 @ thost file = c: \ db.dmp full = y Help command: exp help = y Imp help = y shows

  • Oracle import command imp parameters 2011-06-28

    C: \ Documents and Settings \ Administrator> imp help = ys Import: Release 9.2.0.1.0 - Production on Tuesday June 28 09:03:59 2011 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. You can enter the IMP command and your user name / p

  • oracle exp / imp command 2010-08-27

    Oracle data import and export imp / exp is equivalent to oracle data restore and backup. exp command to export data from a remote database server to the local dmp file, imp command to import the dmp file to the distance from the local database server

  • oracle imp / exp command to explain 2010-09-29

    oracle import and export sources: ChinaUnix blog Date: 2006.06.04 17:41 (0 comments) I want to comment Oracle data import and export imp / exp command - How to import dmp oracle database file? 2006/2/16 zhanghua first create Oracle data import and ex

  • oracle exp / imp command Detailed 2010-10-24

    Oracle data import and export imp / exp is equivalent to oracle data restore and backup. exp command to export the data from the remote database server to the local dmp file, imp command to import the dmp file to the distance from the local database

  • Oracle exp / imp command to import and export database backup (transfer) is more 2011-01-05

    Oracle data import and export imp / exp is equivalent to oracle data restore and backup. exp command to export the data from the remote database server to the local dmp file, imp command to import the dmp file to the distance from the local database

  • Oracle import command imp example (b) 2011-08-04

    C: \ Documents and Settings \ Administrator> IMP bjbtest / bjbtest @ BJBORCL file = F: \ bjb2000_cd \ 02.ER-DB \ test.dmp FROMUSER = bjb2000 touser = tes2 7 full = y Import: Release 9.2.0.1.0 - Production on Tuesday June 28 09:13:08 2011 Copyright (c

  • oracle backup command imp exp 2011-03-28

    oracle backup command for oracle backup and recovery, the following details on how you use the backup command to achieve the oracle oracle backup process, hope you have a better command of the oracle backup understanding. Export EXP USER / PASSWORD @

  • Oracle exp / imp command to import and export database backup (reproduced) 2011-04-02

    Oracle data import and export imp / exp is equivalent to oracle data restore and backup. exp command to export data from a remote database server to the local dmp file, imp command to import the dmp file to the distance from the local database server

  • Database oracle imp / exp 2010-07-26

    db oracle imp / exp Articles Category: Database using Oracle 10g Data Pump (EXPDP / IMPDP) http://junmail.javaeye.com/blog/215780 I. Overview of Data Pump In Oracle 10g, Data Pump (Data Pump) has a database instance for all the work to be completed,

  • Common usage of Oracle exp command 2010-08-27

    Common usage of Oracle exp command TEST 1 full export database, user name, password manager system to export to the D: \ daochu.dmp in exp system / manager @ TEST file = d: \ daochu.dmp full = y 2, the database system user to export the table with th

  • (R) oracle imp / exp 2011-07-15

    Learn oracle feeling very strong ah want to use it as their own database of projects, but do not know how to import \ export database Here is some effort to find himself in the imp command to import \ export Import IMP Oracle's import utility (Import

  • Optimizing Oracle IMP Several large data summary 2010-05-04

    Information: Due to the need 300W with oracle imp tool to import records into a table, use the simplest statement imp file = XXX.dmp full = y ignore = y. results of a long wait for nearly an hours to complete the import. (Hardware is a Dell 2850, mem

  • Oracle table space description of the problem set 2010-06-09

    The following article is mainly meant to set the Oracle table space description of the problem, we all know that a lot of Oracle database table, be a total of more than 600 tables, you can probably account for more than a dozen G space. The following