Re: Copying tables between users

From: Jerry Gitomer <jgitomer_at_ictgroup.com>
Date: Thu, 10 Sep 1998 08:27:59 -0400
Message-ID: <6t8ghe$k5$1@client2.news.psi.net>

Hi Nick,

Use the Oracle exp and imp utilities to do it. These are run from the command line (on NT there is a graphic interface, but I still prefer running from an "MS/DOS" window since not all parameters were available on the GUI the last time I tried it). The syntax is something like (check $ORACLE_HOME/bin in order to determine the exact name of the executables since a release number may be part of the name):

exp <user>/<password>

Just respond to the prompts to export the table you want with all rows and grants.

Then import them back into the database using the imp utility.

imp <user>/<password> fromuser=<old_user> touser=<new_user>

regards

Jerry

Nick Lehane wrote in message
<01bddca3$a1dc6f00$eb58ea9e_at_ukp016543.logica.co.uk>...
>Hi everyone,
>
>My question is as follows:
>
>I currently have some tables under a user in Oracle 7 which I would like to
>move across to another user. The current user is called ops$dmdba and has
>about 10 tables which I would like to move across to a user called demo.
>Could anyone please tell me if there is an easy way of doing this or do I
>have to get the chap back from Oracle who migrated the data in the first
>place?
>
>Many thanks in advance,
>
>Nick Lehane
Received on Thu Sep 10 1998 - 07:27:59 CDT