Copying tables between users

From: Nick Lehane <lehanen_at_logica.com>
Date: 10 Sep 1998 10:13:26 GMT
Message-ID: <01bddca3$a1dc6f00$eb58ea9e@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 - 05:13:26 CDT