-----Original Message-----
From: John Pitman [mailto:[log in to unmask]]
Sent: Friday, October 01, 2004 7:59 AM
To: [log in to unmask]
Subject: RE: [HP3000-L] SQL commands like Adager dbschema listing?

We used to use a script that just did series of
Drop table x
Create table x  (......)

Ie the original data base creation script prefixed with the drop commands.

jp

-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]]On Behalf Of
Art Bahrs
Sent: Friday, October 01, 2004 2:58 AM
To: [log in to unmask]
Subject: Re: [HP3000-L] SQL commands like Adager dbschema listing?

Hi Richard and Others :)
    A quick summary and Thanks for help!

   First, most all suggested (and it worked sorta) doing the TRUNCATE TABLE
command to clear the 'datasets' out.  Also, several replies confirmed that
I was doing my backups right and the detach/copy/reattach method was good
to go for making a reserve copy.

   Michael Gueterman pointed in the right direction of how to create a
blank copy by use of the Enterprise Manager.  I now have a blank copy and a
physical copy located in a 'safety' directory on a different machine.

   The issue with the TRUNCATE TABLE command is every table in this
database has 1 or more (some have 7+) foreign key constraints!  and I am
not sure how to 'deactivate' 'em so the TRUNCATE TABLE command can work.
Any Idears?

   The goal was turn off the foreign key constraints, truncate the table,
turn on foreign key constraints.


thanks,
Art "Learning Quick :) " Bahrs


=======================================================
Art Bahrs, CISSP           Information Security          The Regence Group
(503) 553-1425              FAX (503) 553-1453


|---------+-------------------------------->
|         |           "Richard Barker"     |
|         |           <Richard.Barker@virgi|
|         |           n-exp.com>           |
|         |           Sent by: "HP-3000    |

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *