Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Exporting and imporing table data to another user
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
![]() |
![]() |