Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Exporting and imporing table data to another user

Re: Exporting and imporing table data to another user

From: Robert H. Thompson <rthomp41_at_ford.com>
Date: Tue, 12 Jan 1999 15:55:30 -0500
Message-ID: <369BB6C2.52F17296@ford.com>


Sure you can use the exp and imp functions to export the table and table data by using a parameter file.

say you have a file called export_stuff.par containing the following statements:

TABLES=(REGION, GROUPS)
BUFFER=131070
FEEDBACK=100
ROWS=Y
LOG=EXP01.LOG
FILE=EXP01.DMP this would export the contents of the region and group tables and write the contents to to a file called exp01.dmp and any results of the operation to a file called exp01.log

to run this you would use

exp <userid>/<password>parfile=export_stuff.par

to do an import say you have a file called import_stuff.par containing the following statements:

TABLES=(REGION, GROUPS)
BUFFER=131070
FEEDBACK=100
IGNORE=Y
ROWS=Y
LOG=IMP01.LOG
FILE=EXP01.DMP this would read the contents of the exp01.dmp file and import them into the region and groups tables. any results would be written to a log file called imp01.log.

to run this you would execute the following:

imp <userid>/<password> parfile=import_stuff.par

Kim Amouche wrote:
>
> Hi !
>
> I have successfully used Oracles IMP and EXP utility to move data from
> one database to another database.. But I would like to move some
> tables and/or table data from one DB user to another DB user.
>
> Anyway of doing this with EXP / IMP ?
> If not what other tool can I use ?
>
> I have an Oracle 7.3.2 base...
>
> -
> Best Regards - Kim
Received on Tue Jan 12 1999 - 14:55:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US