How to purge/truncate a 3dcitydb? about 3dcitydb HOT 3 CLOSED

You could use the DROP_DB.sql script. No need to drop the user. We have also designed a procedure called cleanup_schema in the citydb_delete package. It performs a delete on every table and resets the sequences. Since Oracle 12cR1 there's also the option to use TRUNCATE ... CASCADE. This is what we also use in the PostgreSQL version and it's very fast no matter how big the DB is (around 15 sec). From the docs it seems that foreign key constraints need to be set to ON DELETE CASCADE. We also have a procedure for this called update_schema_constraints in the citydb_util package. So, you could try to write your own PLSQL function. For backwards compability reasons (to 11g) we will not change it for now.

from 3dcitydb.

Great! That was what I am looking for.
So I can just call this cleanup procedure in sqlplus as
exec citydb_delete.cleanup_schema ?#
Thx for your support!

from 3dcitydb.

Correct. Depending on the amount of data it would take a while, but if if your are testing with only small data sets it should be feasible.

from 3dcitydb.