Re: exporting to Oracle 7 from access

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 24 May 2001 20:40:13 +0200
Message-ID: <tgql8gi0jb8jd2@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
Received on Thu May 24 2001 - 13:40:13 CDT