Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Porting Access tables into Oracle

Re: Porting Access tables into Oracle

From: Jane <jane_at_e-marketing.com>
Date: Fri, 15 Aug 2003 13:10:59 +0800
Message-ID: <bhhq1b$sqb2@rain.i-cable.com>


One more question. Is it possible to generate a " xxxx.sql" file from the oracle schema for backup purpose ?

"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in message news:c1F_a.140627$Ho3.17552_at_sccrnsc03...
> The migration work bench should work just fine. (otn.oracle.com) Oracle
> supports those types.
> Jim
> "Jane" <jane_at_e-marketing.com> wrote in message
> news:bhf5ga$dk22_at_rain.i-cable.com...
> > I've a Access 2002 MDB file which containing just tables.
> > I tried a porting tool by Oracle before, but it said some data type are
> not
> > supported, so I can't use it.
> >
> > The types i m using are just Binary, Text, ineteger and decimals
> >
> > How can I port these tables into Oracle Server without the need to
create
> > the tables in Oracle manually ( Oracle 9i) ??
> >
> > The data can be ignored, I only need the schema.
> >
> > Thanks
> >
> >
>
>
Received on Fri Aug 15 2003 - 00:10:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US