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: [EMAIL PROTECTED] =================================================== 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
