Oracle-L: RE: Imp of all users tables

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Wed, 27 Nov 2002 01:43:40 -0800
Message-ID: <F001.0050D4A1.20021127014340@fatcity.com>

If you are doing this with an export that was taken with the data=n option set (only exporting the tables structures with no data in them), then you could use the DBATool to easily generate the scripts to do this.

http://www.cool-tools.co.uk/products/dbatool.html

HTH Mark

 Mark Leith             | T: +44 (0)1905 330 281
 Sales & Marketing      | F: +44 (0)870 127 5283
 Cool Tools UK Ltd      | E: mark_at_cool-tools.co.uk
===================================================
           http://www.cool-tools.co.uk
       Maximising throughput & performance

-----Original Message-----
Sent: 27 November 2002 02:24
To: Multiple recipients of list ORACLE-L

-----Original Message-----

imp system/pwd fromuser=david touser=david tables=a,b,c,... ignore=y file=expdat.dmp

How can I do all (and not a full=y) of the 544 tables for one user at one time?

Leave out the "tables=....". Then it will default to all the tables of that user.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephen Lee
  INET: slee_at_dollar.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  INET: mark_at_cool-tools.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Wed Nov 27 2002 - 03:43:40 CST