Purpose
oradrop prints the drop statements for all objects in an Oracle database
schema in the correct order (i.e. objects will be dropped so that no errors
happen during script execution). oradrop can also be used to actually
make the schema empty.
Options
oradrop supports the following options:
connectstringAn Oracle connectstring.
-v,--verbose(false,no,0,true,yesor1)Produces output (on stderr) while the database is read or written.
-c,--color(yes,noorauto)Should the output (when the
-voption is used) be colored? Ifautois specified (the default) then the output is colored if stderr is a terminal.-f,--fks(keep,disable,drop)Specifies how foreign keys from other schemas pointing to this schema should be treated:
keepwill not change the foreign keys in any way (this will lead to errors);disablewill disable the foreign keys anddropwill drop them completely.-x,--execute(false,no,0,true,yesor1)When the
-xargument is given the SQL script isn't printed on stdout, but is executed directly. Be careful with this: You will have an empty schema afteroradrop -x.-k,--keepjunk(false,no,0,true,yesor1)If true (the default), database objects that have
$orSYS_EXPORT_SCHEMA_in their name will be skipped (otherwise these objects will be included in the output).-i,--ignore(false,no,0,true,yesor1)If true, any exception that occurs while the database is read or written will be ignored.
--format(sqlorpysql)If
--executeis not given, this determines the output format: Plain SQL, or PySQL which can be piped intoll.pysql.--include(regexp)Only include objects in the output if their name contains the regular expression.
--exclude(regexp)Exclude objects from the output if their name contains the regular expression.