RE: Imp of all users tables

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Wed, 27 Nov 2002 02:09:08 -0800
Message-ID: <F001.0050D53A.20021127020908@fatcity.com>

DOH! I really shouldn't reply without any coffee in the mornings! This should of course read:

"If you are doing this with an export that was taken with the "ROWS=N" option set"

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

Sent: 27 November 2002 09:44
To: Multiple recipients of list ORACLE-L

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).

--

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 - 04:09:08 CST