Notifications
Clear all

Macro to delete database schema contents?

   RSS

1
Topic starter

Hello,

Does anyone have a copy of the macro that deletes all the database schema contents?

Thanks!

You want to empty the contents of tables, or actually drop the tables/indexes/procs/etc?

4 Answers
0
Topic starter

I think emptying the contents should do it.  My Bookstore project went sideways and I'm trying to recover.

0

If you just want to delete the data in your database, but preserve the schema; then one way to do that is to run the following in SQL:

{call dtb.delete_data()}

0

Generally, deleting and adding users is the easiest. If you have system or sysdba access to the database, this is the preferred method.

0

There is also the delete-data ant target that can be run from root:

ant delete-data

 

© 2020 One Network Enterprises. All rights reserved. Privacy Policy