Re: exporting to Oracle 7 from access

From: TurkBear <noone_at_nowhere.com>
Date: Thu, 24 May 2001 14:16:54 -0500
Message-ID: <rbnqgto8i8cqbo7kehnkver2hs21jj651g@4ax.com>

Hi,
It will go into your default tablespace...theer is no way to specify another one using ODBC and Access's export feature...

( BTW, be sure to make the table name UPPER CASE before exporting of you will have problems accessing it with most Oracle tools...Also be sure to check for invalid field names ( reserved words, spaces, etc) and invalid data types...)

>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 ?
>
>will the export automatically go to my default tablespace ?
>
>can anyone give me some insight on this.
>
>thanks
Received on Thu May 24 2001 - 14:16:54 CDT