Home » RDBMS Server » Server Utilities » Re: Access to Oracle
Re: Access to Oracle [message #69497] Tue, 22 January 2002 00:32
Abdullah Gilani
Messages: 18
Registered: October 2001
Junior Member
hi Jayakumar

When you exported tables from access to oracle
it would have created table names with Mixed cases letters Table Name plus double quotation marks,
Like for EMPLOYEE it may be "EMPLOYEE".......this is("EMPLOYEE") 100% Case Sensitive
if you give the table name with in "" then it will be stored as it is.

Bascially Oracle Server convert Table name into double quotation marks like EMPLOYEE to "EMPLOYEE"

you may run the following Query in Scott Scema,

SQL> select "EMPNO" ,"ENAME" ,"JOB" from "EMP";

==== For Remove double quotation marks from Table Name ====

For Remove double quotation marks from Table Name, Use CREATE TABLE command with AS SELECT option Like,

SQL> CREATE TABLE employee AS SELECT * FROM "EMPLOYEE";

Table created.

Now you may DROP the imported table,

SQL> DROP TBALE "EMPLOYEE";

Table dropped.

Now you Create Constraints and References, Because CREATE TABLE AS SELECT command can't create Constraints and References. Only NOT NULL constraint created.

Thanks & Regards,

Abdullah Gilani,
Database Administrator
&
Systems Analyst.
Email: syedgilani@hotmail.com
Previous Topic: Re: How to run the SQL script as a scheduled job?
Next Topic: foreign key
Goto Forum:
  


Current Time: Sun Feb 25 02:04:05 CST 2024