Re: [Porting SYBASE data to Oracle Database]

From: Yigal Ran <ydran_at_usa.net>
Date: 11 Aug 00 10:11:05 EDT
Message-Id: <10586.114357@fatcity.com>

Check out this address
http://www.datamirror.com/products/sqlpump/features.html

Yigal

Winnie_Liu_at_infonet.com wrote:
> To all listers,
> =

> Is anyone know of any good product which can help to port Sybase data t=
o
> Oracle database?
> =

> We don't want to use the transparent gateway on Oracle side, we actuall=
y
> want to get the Sybase data out and put them inside the Oracle database=
=2E
> =

> Any one have any good suggestions?
> =

> Thanks! :)
> =

> Winnie
> =

> =

> -- =

> Author: =

> INET: Winnie_Liu_at_infonet.com
> =

> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

---

Get free email and a permanent address at http://www.amexmail.com/?A=3D1

---

 From: Rajagopal Venkataramany <rajagopalvr_at_excite.com>  Date: Fri, 11 Aug 2000 07:22:49 -0700 (PDT)  Subject: Re: serverouput buffer overflow

Hi,

 Using UTL_FILE command would be the ideal solution to this. However,  if you are working from a windows client and find it difficult=20  to log into the db server machine, to see the file, then u can  insert all the details u want into a temp table and use sqlplus  to generate a report from the table.

Regards
Rajagopal Venkataramany

On Thu, 10 Aug 2000 08:31:53 -0800, ORACLE-L_at_fatcity.com wrote:

> Does anyone know how I can work around the 1000000 limit for server
output?
> =20
> I have a cursor that makes a list of all the indexes in a database, then
I
> use that to generate sql to file to analyze them in turn plus store thei=
r
> sizing info into a separate table.
> =20
> Unfortunately there is so much information generated in the cursor that
when
> I use dbms_output to produce the SQL, I reach the limit.
> =20
> Sqlplus only seems to spool once the command has finished, in this case
> until the whole PL/SQL loop has finished.
> =20
> I would prefer not having to break up the job into smaller cursors.
> =20
> TIA
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
> =20
> Systems Admin & Operations | Admin. et Exploit. des syst=E8mes
> Technology Services | Services technologiques
> Informatics Branch | Direction de l'informatique=20
> Maritimes Region, DFO | R=E9gion des Maritimes, MPO
> =20
> --
> Author: Boivin, Patrice J
> INET: BoivinP_at_mar.dfo-mpo.gc.ca
> =20
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
Received on Fri Aug 11 2000 - 09:11:05 CDT