contact contact

dbpurge utility

» Usage | Notes | Examples | See also
  The dbpurge utility deletes a given database, including the the database structure (schema) and returns space to the free space pool of the database volume files.


usage: dbpurge [options] database
 -help   - show usage (this list)
 -u user - set user name
 -p pswd - set password
 -f      - force database purge
 -d flgs - debug flags

The options are:
The -help option displays a brief help text.

-u user
The -u option specifies the database user (or a file holding the database user and/or password). Defaults to the dba user unless a default user is specified with the EQ_DBUSER environment variable.

-p password
The -p option may be used to specify the password for the database user (or a file holding the password). If not specified, the password is obtained using the EQ_DBUSER and/or EQ_DBPASSWORD environment variables.

The -f option forces to purge the database, even if deletion of sets fails.

-d flags
The -d option specifies debug flags and is normally not used.


  • The database to be purged may not be opened by any users.

  • The database user performing dbpurge needs to have DBA or OPERATOR privileges, or else be member of a group that has DADMIN group privileges for the target database.


dbpurge MyDB

See also

schema, dbschema, dbcreate, dberase.

  Privacy | Webmaster | Terms of use | Impressum Revision: 2014-08-14  
  Copyright © 1995-2022 Marxmeier Software AG