Please help with Drop Database problem

Database
IYA
Enthusiast

Please help with Drop Database problem

Dear there,

I've created a database by using example sql:

CREATE DATABASE finance
FROM ApplDb
AS
PERM = 2000000
SPOOL = 5000000
FALLBACK
ACCOUNT= 'ACCTG'
NO AFTER JOURNAL
DUAL BEFORE JOURNAL
DEFAULT JOURNAL TABLE = finance.journals;

I didn't create table or other views inside. However, I can't drop the database by drop sql.

I guess is the journal table gives me problem. But what shall I do for it?

Your advice is greatly appreciated!
3 REPLIES
Senior Apprentice

Re: Please help with Drop Database problem

Only empty databases might be dropped, so you have to drop that journal table:

modify database finance as
drop default journal table;

Dieter
Enthusiast

Re: Please help with Drop Database problem

Permanent journals created and forgotten are potential source of frustration for the beginners. :-)
Enthusiast

Re: Please help with Drop Database problem

excellent.. its working and database gone....