Re: Oracle->Postgres Migration Problems.

Can you view the columns in the table on Oracle using an ODBC tool like
Microsoft Query?

Regards, Dave.

> -----Original Message-----
> From: David Griffiths [mailto:dgriffiths(at)boats(dot)com]
> Sent: 16 April 2002 17:31
> To: Dave Page; pgadmin-support(at)postgresql(dot)org
> Subject: Re: [pgadmin-support] Oracle->Postgres Migration Problems.
>
>
> Yup - I'm the DBA for the database, and was logging in with a
> user with the DBA role assigned to them. I've also selected
> from the 'col' view on Oracle to see the columns as that user.
>
> David.
>
> ----- Original Message -----
> From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
> To: "'David Griffiths'" <dgriffiths(at)boats(dot)com>;
> <pgadmin-support(at)postgresql(dot)org>
> Sent: Tuesday, April 16, 2002 12:59 AM
> Subject: RE: [pgadmin-support] Oracle->Postgres Migration Problems.
>
>
> > Hi David,
> >
> > Do you have sufficient privileges on the Oracle system? I have seen
> > both Oracle & MS SQL Server fail to return column names in the past
> > when the
> uid
> > had sufficient privileges to connect and see that a table
> existed, but
> > not to look at the table structure.
> >
> > Regards, Dave.
> >
> > > -----Original Message-----
> > > From: David Griffiths [mailto:dgriffiths(at)boats(dot)com]
> > > Sent: 15 April 2002 22:33
> > > To: pgadmin-support(at)postgresql(dot)org
> > > Subject: [pgadmin-support] Oracle->Postgres Migration Problems.
> > >
> > >
> > > I am trying to use the migration plugin to migrate my tables and
> > > data from Orace 8i to Postgres 7.2 on Redhat 7.2
> > >
> > > I'm doing a small test to see how well it works, but I'm
> not getting
> > > very far. I have Oracle installed, and have a System DSN
> setup. If I
> > > pick a standard table (varchars, numbers,
> > > dates) and do the conversion, I get:
> > >
> > > An error occured at: 15/4/2002 2:24:42 PM:
> > > 9: Subscript out of range
> > >
> > > Rolling back... Done.
> > >
> > > I read through the mailing archive, and noticed that Dave
> had asked
> > > that debugging turned on and the contents of the log
> window sent, so
> > > that's what I've done (nothing else in there that I could find).
> > > I've just subscribed to the mailing list, but I've looked to make
> > > sure I wasn't posting a topic that had been answered
> earlier; but if
> > > I've missed it, I apologize.
> > >
> > > The logs are below (note that I asked for lower-case
> conversion of
> > > all tables, indexes, etc). I x'd out any connection info for
> > > security reasons.
> > >
> > > BTW, a great tool, aside from this little glitch.
> > >
> > > David
> > >
> > >
> > > 15/4/2002 2:24:41 PM - Entering pgSchema:pgServer.ExecSQL("BEGIN",
> > > "Connection: Provider=MSDASQL.1;Extended
> > > Properties="DRIVER={PostgreSQL};DATABASE=xxx;SERVER=192.168.12
> > .137;PORT=5
> > > 432;UID=postgres;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;S
> > > HOWOIDCOLUMN=0
> > > ;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;FETCH=100;SO
> > > CKET=4096;UNKN
> > > OWNSIZES=0;MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;DEBUG=1
> > > ;COMMLOG=1;OPT
> > > IMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNS
> > > ASLONGVARCHAR=
> > > 1;BOOLSASCHAR=1;PARSE=0;CANCELASFREESTMT=0;EXTRASYSTABLEPREFIX
> > > ES=dd_"")
> > > 15/4/2002 2:24:41 PM - SQL (xxxx): BEGIN
> > > 15/4/2002 2:24:41 PM - Creating table: BOATS
> > > 15/4/2002 2:24:41 PM - Entering Database Migration
> > > Wizard:frmWizard.txtStatus_Change()
> > > 15/4/2002 2:24:42 PM - Entering Database Migration
> > > Wizard:frmWizard.txtStatus_Change()
> > > 15/4/2002 2:24:42 PM - Entering pgSchema:pgServer.Property Get
> > > Databases() 15/4/2002 2:24:42 PM - Entering
> > > pgSchema:Databases.Property Get
> > > Item("xxxx")
> > > 15/4/2002 2:24:42 PM - Entering
> > > pgSchema:pgDatabase.Execute("ROLLBACK",
> > > 0, -1)
> > > 15/4/2002 2:24:42 PM - Entering
> > > pgSchema:pgDatabase.dbConnect() 15/4/2002 2:24:42 PM - Entering
> > > pgSchema:pgServer.ExecSQL("ROLLBACK",
> > > "Connection: Provider=MSDASQL.1;Extended
> > > Properties="DRIVER={PostgreSQL};DATABASE=xxxx;SERVER=192.168.1
> > 2.137;PORT=5
> > > 432;UID=postgres;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;S
> > > HOWOIDCOLUMN=0
> > > ;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;FETCH=100;SO
> > > CKET=4096;UNKN
> > > OWNSIZES=0;MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;DEBUG=1
> > > ;COMMLOG=1;OPT
> > > IMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNS
> > > ASLONGVARCHAR=
> > > 1;BOOLSASCHAR=1;PARSE=0;CANCELASFREESTMT=0;EXTRASYSTABLEPREFIX
> > > ES=dd_"")
> > > 15/4/2002 2:24:42 PM - SQL (xxxx): ROLLBACK
> > > 15/4/2002 2:24:42 PM - Entering Database Migration
> > > Wizard:frmWizard.txtStatus_Change()
> > > 15/4/2002 2:24:42 PM - Done - 1.54 Secs.
> > >
> > >
> > > ---------------------------(end of
> > > broadcast)---------------------------
> > > TIP 3: if posting/reading through Usenet, please send an
> appropriate
> > > subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> > > message can get through to the mailing list cleanly
> > >
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an
> appropriate subscribe-nomail command to
> majordomo(at)postgresql(dot)org so that your message can get through
> to the mailing list cleanly
>