Extract Primary Key Information
- Reverse Engineer the Primary Keys into a script from the database
(Added: 13-Aug-1999 Hits: 7020 Rating: 8.57 Votes: 7) Rate It
Extract Views
- Extract the code for views from the database
(Added: 13-Aug-1999 Hits: 6591 Rating: 3.25 Votes: 16) Rate It
Reverse Engineer constraints
- Output is written to ddl_re_cons.out. You'll need to run this output to recreate the constraints.
(Added: 14-Jul-2000 Hits: 7067 Rating: 7.71 Votes: 7) Rate It
Reverse Engineer Objects
- This package creates two type flat file with the reverse engineer schema DB for an object.
(Added: 30-Oct-2002 Hits: 6102 Rating: 7.15 Votes: 13) Rate It
Reverse Engineer Tablespaces
- This script generates another with the reverse engineer code for all tablespaces in the database. For Oracle database versions : 7.x/8.x/9.x
(Added: 18-Dec-2002 Hits: 4669 Rating: 4.81 Votes: 11) Rate It
Reverse engineering database users
- Build another script that contains SQL CREATE USER related to all database user accounts. The script is generated based on info account status (open, locked and/or expired). It works only with Oracle8i and Oracle9i versions.
(Added: 7-Oct-2003 Hits: 4010 Rating: 5.50 Votes: 2) Rate It
Reverse engineering tablespaces (only Oracle9i 9.2)
- This script build create a tablespace script retrieving all column values from dba_tablespaces in Oracle9i R2 databases, such as block_size, segment_space_management, force_logging columns, when these options are being used.
(Added: 9-Oct-2003 Hits: 3184 Rating: 9.33 Votes: 3) Rate It
Reverse tablespaces
- (updated) This script build an another that generates CREATE TABLESPACE for all tablespaces in the database (except SYSTEM). It use dynamic SQL that turns it possible to be executed in Oracle7/8/8i/9i database versions. It automatically sets unlimited as maxsize for datafiles that autoextend on.
(Added: 6-Oct-2003 Hits: 3461 Rating: 4.00 Votes: 3) Rate It
