In DTS you can choose to copy only the data and not create the tables by
mapping the corresponding fields. Check the options in the DTS Import/Export
wizard.



Regards

Partha Mandayam
Software Consultant
Home page: http://partha.tripod.com






>From: "Rahmani Roya "
><mssqldba-ezmlmshield-x76975164.[Email address protected]
>To: "LazyDBA Discussion" <[Email address protected]
>Subject: importing data to oracle 9i from Sql sever
>Date: Thu, 29 Jul 2004 11:58:05 -0400
>Received: from www.websitesondatabases.com ([216.55.183.38]) by
>mc4-f37.hotmail.com with Microsoft SMTPSVC(5.0.2195.6824); Thu, 29 Jul 2004
>08:58:58 -0700
>Received: (qmail 17114 invoked by uid 121); 29 Jul 2004 15:57:40 -0000
>Received: (qmail 28355 invoked from network); 29 Jul 2004 15:57:40 -0000
>X-Message-Info: JGTYoYF78jFlR+QDGdxUdtPL+Ofdx5gJ
>Mailing-List: contact mssqldba-[Email address protected] run by ezmlm
>Precedence: bulk
>X-No-Archive: yes
>List-Post: <mailto:[Email address protected]
>List-Help: <mailto:mssqldba-[Email address protected]
>List-Unsubscribe: <mailto:mssqldba-[Email address protected]
>List-Subscribe: <mailto:mssqldba-[Email address protected]
>Delivered-To: mailing list [Email address protected]
>Message-ID: <20040729155740.17112.[Email address protected]
>Return-Path: mssqldba-return-7380-MCP111=hotmail.[Email address protected]
>X-OriginalArrivalTime: 29 Jul 2004 15:58:58.0343 (UTC)
>FILETIME=[F537E370:01C47584]
>
>Dear Fellows,
>I m new to Oracle and have a project that involves data migration form SQL
>server 2000
>to Oracle9i. The deal is that I just need some tool to map the data from
>SQL
>server to oracle and I have the schema for oracle already. I tried DTS but
>it starts with creating the objects(tables,..), which I don't need since I
>have the schema in Oracle I just want to pump data to the right columns
>with
>correct data type.Any ideas?
>your input int this respect is highly appreciated.
>
>best regards,
>RR
> >
> >
> > ---------------------------------------------------------------------
> > TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> > Website : http://www.LazyDBA.com
> > To unsubscribe: http://www.lazydba.com/unsubscribe.html
> > For additional commands, e-mail: mssqldba-[Email address protected]
> >
> >
> >
> >
> >
>***********************************************************************
> > NOTICE: This electronic mail message and any attached files are
> > confidential. The information is exclusively for the use of the
> > individual or entity intended as the recipient. If you are not the
> > intended recipient, any use, copying, printing, reviewing, retention,
> > disclosure, distribution or forwarding of the message or any attached
> > file is not authorized and is strictly prohibited. If you have
> > received
> > this electronic mail message in error, please advise the sender by
> > reply
> > electronic mail immediately and permanently delete the original
> > transmission, any attachments and any copies of this message from
> > your
> > computer system.
> >
>***********************************************************************
> >
> >
> > ---------------------------------------------------------------------
> > TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> > Website : http://www.LazyDBA.com
> > To unsubscribe: http://www.lazydba.com/unsubscribe.html
> > For additional commands, e-mail: mssqldba-[Email address protected]
> >
> >
> >
> > ---------------------------------------------------------------------
> > TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> > Website : http://www.LazyDBA.com
> > To unsubscribe: http://www.lazydba.com/unsubscribe.html
> > For additional commands, e-mail: mssqldba-[Email address protected]
> >
> >
>
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>Website : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>For additional commands, e-mail: mssqldba-[Email address protected]
>
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>Website : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>For additional commands, e-mail: mssqldba-[Email address protected]
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>Website : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>For additional commands, e-mail: mssqldba-[Email address protected]
>



MS Sql Server LazyDBA home page