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:[EMAIL PROTECTED]] > Sent: 15 April 2002 22:33 > To: [EMAIL PROTECTED] > 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 > [EMAIL PROTECTED] 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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
