Re: Help! - MS Access --> O7 Windows

From: Noah Monsey <noah_at_indirect.com>
Date: Fri, 27 Jan 1995 01:35:30 GMT
Message-ID: <D31J36.8u1_at_indirect.com>


Douglas Hackney (hackneyd_at_ix.netcom.com) wrote:
: Problem: In exporting data from MS Access 2.0 to Oracle 7 for Windows
: (O7W) column names are being surrounded with "
 

: Background: I'm building a sales laptop system using O7W. The data is
: currently in a MS Access 2.0 database. The MS Access 2.0 Export:SQL
: Database:Oracle7 process works without a hitch, except that the column
: names are being preceded and followed with ". The " characters are not
: appearing when I query the system tables to show the column names, I
: discovered them by looking at the SQL string from a successful Browser
: test query.
 

: Using SQL Plus O7W reports "invalid column name" if I don't include the
: " (select smdemo.branch."city" from smdemo.branch), browser is seeing
: the " when it loads the schema, another query tool (Andyne GQL) is not
: seeing the " when it downloads the schema.
 

: Timeline: This system is due by the end of the week (typical bleeding
: edge development cycle).
 

: Questions:
: 1. is it possible to export from MS Access 2.0 to O7W without getting
: the " around the column names?
: 2. is it possible to edit the column names in O7W to remove the "?
An easy solution would be two create a new table with a select statement .. for example
create table new_table as
select column_a a_column,
column_b b_column
from old_table;

By putting the alias for each column after the name of the column the new table is created with the new column name

: 3. is it possible to do a global search & replace on the column names in
: O7W to get rid of the "?

Their are tables which list all of the columns in the entire database. In a version 6 rdbms there are data dictionary tables which list all tables "dba_tab_columns" a user with dba privleges Searching would be easy, for example

select user_name,table_name,column_name from dba_tables
order by user_name,table_name,column_name;

the order by would be usefull to make sure you know which user and table each column belongs to.

I cant think of any way to change column names except by creating a new table.

: Any assistance would be appreciated.
: --
: -----------------------------------------------------------------------
: Doug Hackney Hackney-D_at_clavin.med.ge.com
: '94 RF900R '93 DR350S '87 GSX-R11 '72 Norton 750 Commando

........................................................................
An unemployed dba
.................................................. sig version .9 beta 
Noah Monsey           Oracle Master  Database Administration  April 92  
noah_at_indirect.com     Oracle Master  Application Development  April 92
Received on Fri Jan 27 1995 - 02:35:30 CET

Original text of this message