Re: duplicate tables & grants

From: Anatoly Moskovsky <avm_at_trais.com.ua>
Date: Wed, 12 Sep 2001 10:25:48 +0300
Message-ID: <TRS1514642A4@trais.com.ua>

Hi!

• On september 11 @nnib wrote:

 n> hi,

 n> I've got 3 users SU, SU1 and SU2

 n> SU own 100 tables
 n> SU1 own 100 tables with the same names
 n> SU2 has grant on all the SU and SU1 tables.

 n> I need to refresh the SU1 tables with the content of SU (before an  n> Euro migration)

 n> I think to :
 n> 1 / drop all the SU1 tables 2 / exp the SU tables 3 / imp fromuser=SU
 n> touser=SU1

 n> but what's about the grants ???

 n> I think SU2 couldn't access to SU1 tables after...('cause of the  n> drop)

You shouldn't drop the tables. Truncate them instead and then run import with ignore=y
This will load data into existing tables. Also, you can avoid using import at all: use "insert ... select ..."

Bye

---

Anatoly Moskovsky, Oracle Developer avm_at_sqlbatch.com [SQL Batch/Oracle, DBA tools, reverse engineering, scripting extensions]: http://sqlbatch.com/sb/ Received on Wed Sep 12 2001 - 02:25:48 CDT