DBScripter for Oracle is a database utility that creates a script from any Oracle database`s data, objects and/or source. A script is a series of SQL commands that, when run, will create a replication of the database, or a portion of the database.
Scripts can be used to migrate data, upgrade databases, and even as a database backup. DBScripter allows you to customize the script that will be created, you can select which objects or source to script, you can also add conditions to the data script thus scripting only a subset of the data.
You can also ignore columns to be scripted, both for structural scripts (DDL) and data scripts (DML). DBScripter also comes with a SQL Script feature that allows you to manually type a select statement and have it`s results scripted.
Any Oracle database can be scripted, the databases do not need to be local, as long as they are accessible from the machine running DBScripter using an Oracle client 8.