diff options
| author | Bruce Momjian <bruce@momjian.us> | 2001-05-13 02:10:00 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2001-05-13 02:10:00 +0000 |
| commit | 904ba3ff69e1402bc2042807fd1d37f8570bfea1 (patch) | |
| tree | 0abff2f3a24df1af18e97b74ddcbba5747540086 /contrib/oracle/ora2pg.pl | |
| parent | 911a4981763cba58548139dc5c097d8961310d86 (diff) | |
| download | postgresql-904ba3ff69e1402bc2042807fd1d37f8570bfea1.tar.gz | |
Update to ora2pg 1.2.
Diffstat (limited to 'contrib/oracle/ora2pg.pl')
| -rwxr-xr-x | contrib/oracle/ora2pg.pl | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/contrib/oracle/ora2pg.pl b/contrib/oracle/ora2pg.pl index 00830694cc..8b8e530235 100755 --- a/contrib/oracle/ora2pg.pl +++ b/contrib/oracle/ora2pg.pl @@ -20,7 +20,7 @@ use strict; use Ora2Pg; # Initialyze the database connection -my $dbsrc = 'dbi:Oracle:host=aliciadb.samse.fr;sid=ALIC;port=1521'; +my $dbsrc = 'dbi:Oracle:host=test.mydomain.com;sid=TEST;port=1521'; my $dbuser = 'system'; my $dbpwd = 'manager'; @@ -29,6 +29,12 @@ my $schema = new Ora2Pg ( datasource => $dbsrc, # Database DBD datasource user => $dbuser, # Database user password => $dbpwd, # Database password + debug => 1, # Verbose mode +# type => 'VIEW', # Extract views +# tables => [('MY_TABLE1','MY_TABLE2')], # Extract only these table +# showtableid => 1, # Display only table indice during extraction +# min => 1, # Extract begin at indice 1 +# max => 10 # Extract ended at indice 10 ); # Create the POSTGRESQL representation of all objects in the database |
