Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

How to import oracle tables to Adaptive Server Enterprise?

3 posts in Windows NT Last posting was on 2000-10-30 16:24:54.0Z
danny.nguyen Posted on 2000-10-19 19:59:30.0Z
From: danny.nguyen@cp.net
Date: Thu, 19 Oct 2000 15:59:30 -0400
Newsgroups: sybase.public.sqlserver.nt
Subject: How to import oracle tables to Adaptive Server Enterprise?
Message-ID: <B54BB2CBB6A6087B006DD1618525697D.006DD16E8525697D@webforums>
Lines: 9
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.nt:1559
Article PK: 1089037

Hi there,
I exported some tables from Oracle database in extension ".dmp" I would
like to import these table into Adaptive Server Enterprise, I have tried
with bcp command but it does not work. Anyone can help me how to external
table into Adaptive server? what tool should I use to import?

Thanks,

Danny


Anonymous Posted on 2000-10-30 16:24:54.0Z
From: Anonymous@sybase.com
Date: Mon, 30 Oct 2000 11:24:54 -0500
Newsgroups: sybase.public.sqlserver.nt
Subject: Re: How to import oracle tables to Adaptive Server Enterprise?
Message-ID: <544C6BD64D571FC7005A2B8E85256988.007146238525697D@webforums>
References: <B54BB2CBB6A6087B006DD1618525697D.006DD16E8525697D@webforums>
Lines: 7
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.nt:1539
Article PK: 1089017

CIS(Component Integration Services) may provide you a good alternative.
Create one small database and create proxy-tables and map these tables
to oracle database and then sql like
"insert into yourdb..yourtable select * from proxydb..proxytables"
Read Sybase CIS Manual for more details.


"Mark A. Parsons" <pegasys Posted on 2000-10-20 17:24:23.0Z
Message-ID: <39F07FC6.402B0B84@_internet.co.nz>
Date: Sat, 21 Oct 2000 06:24:23 +1300
From: "Mark A. Parsons" <pegasys@_internet.co.nz>
Organization: Pegasys (2000) Limited
X-Mailer: Mozilla 4.72 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: How to import oracle tables to Adaptive Server Enterprise?
References: <B54BB2CBB6A6087B006DD1618525697D.006DD16E8525697D@webforums>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 26
NNTP-Posting-Host: p311.ipa1-n8-16.iconz.net.nz 210.48.25.55
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1557
Article PK: 1089033

> I exported some tables from Oracle database in extension ".dmp"

Whats the format of a .dmp file? If you used Oracle's 'export' command ...
the resultant file cannot be used by Sybase's bcp.

> I would
> like to import these table into Adaptive Server Enterprise, I have tried
> with bcp command but it does not work. Anyone can help me how to external
> table into Adaptive server? what tool should I use to import?

Sybase's bcp tool uses OS files (that contain *only* data) that are either
delimited (eg, tab delimited) or have a fixed format (eg, use a format file
to describe layout). Any other format is not readable by bcp.

There may be a tool out there which can convert your Oracle .dmp file ... but
your best bet is to put your Oracle data into, say, a tab-delimited file
format (of course, this requires that you find, or design, the equivalent of
a sql-un-loader).

--
Mark A. Parsons

Iron Horse, Inc. iron_horse@compuserve.com
Pegasys (2000), Ltd pegasys@internet.co.nz