Good point - I should have mentioned that.. Thanks Kimberly.
-Original Message-
Smith
Sent: 30 November 2001 17:47
To: Multiple recipients of list ORACLE-L
Hum, must disagree (sort of). Although I don't recommend creating objects
as system normally the first thing I do when I create a
In oracle what ever the case we use while creating object name, the data
dict willbe updated in upper case.
eg: emp/Emp/EMP are all same for oracle.
(if table is created without double quotes. eg: create table emp (col1 ,
col2 ..)
But in any case if we want to create any object with specific
Mark,
I am a really confused with your last statement.
"Have you tried either of the following:
select * from "tblBundleCon";
select * from 'tblBundleCon';
If you really did create them in lower and upper case, this could be your
problem. Enclosing the table names in double quotes usually solves
Hum, must disagree (sort of). Although I don't recommend creating objects
as system normally the first thing I do when I create a database is change
the default tablespace of all users except sys. OK, it might not be the
first thing I do, but its up there in the beginning somewhere.
You could a
Jyoti,
Did you create the tables as SYSTEM? One thing I will say is that *YOU
SHOULD NOT DO THIS*. When creating objects as SYSTEM, these objects will be
stored in the SYSTEM tablespace - which is not a good idea. As system,
create another tablespace (if one does not already exist), create a new
Hi all,
I have created with the following
details:
Global DB name: manu.ifpjyo
SID:
manu
Username:
SYSTEM
Password:
manager
Tables:
tblBundleCon, tblTextCon, tblFinalImage
I am able to connect to the database:
SQL> connect system@ma