Re: exporting to Oracle 7 from access

From: hani <hanton32_at_hotmail.com>
Date: 24 May 2001 20:06:32 -0700
Message-ID: <8dc139d4.0105241906.2611ae18@posting.google.com>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<tgql8gi0jb8jd2_at_beta-news.demon.nl>...
> Answers embedded
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> "hani" <hanton32_at_hotmail.com> wrote in message
> news:8dc139d4.0105241017.11144ec9_at_posting.google.com...
> > I am exporting a table from ms access 97 to personal oracle 7 for Win
> > 95 using ODBC. is there a way to specify the target tablespace ?
>
> Only if you precreate the table either using sql*plus or as a passthru query
> in Access
> >
> > will the export automatically go to my default tablespace ?
>
> Yes, if you didn't follow the procedure above
> >
> > can anyone give me some insight on this.
> >
> > thanks

Sybrand,

I tried already tried 'precreating' the table in in sql*plus and then exporting from access but I get an error that the table already exists.

hani Received on Thu May 24 2001 - 22:06:32 CDT