| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
