'
-Original Message-From: John Shaw
[mailto:[EMAIL PROTECTED]]Sent: 20 January 2003
15:31To: Multiple recipients of list ORACLE-LSubject:
SQLplus question unusual behavior
I am trying to update a small table from a remote table with sqlplus
9.2.0.2 .
It seems to indicate
recipients of list ORACLE-L
Subject: Re: SQLplus question unusual behavior
Check if there are two taables named FACILTY in your database.
As SYS, check
SELECT OWNER, Object_name, Object_type
FROM DBA_OBJECTS
WHERE UPPER(OBJECT_NAME) = 'FACILITY'
Note the use of upper(). Someone might
or a
subordinate user?
Check in the USER / DBA_POLICIES view where
the OBJECT_NAME='FACILITY'
-Original Message-From: John Shaw
[mailto:[EMAIL PROTECTED]]Sent: 20 January 2003
15:31To: Multiple recipients of list ORACLE-LSubject:
SQLplus question unusual behavior
I am trying
I bounced the
databases and just like rebooting a pc (even though this db is on solaris) it
started working - one of the mysteries of Oracle - Maybe it was really windy and
it was having sympathy pains with the yacht.
[EMAIL PROTECTED] 01/20/03 08:44PM John Shaw
wrote: I am trying to update
John Shaw wrote:
I bounced the databases and just like rebooting a pc (even though this
db is on solaris) it started working - one of the mysteries of Oracle -
Maybe it was really windy and it was having sympathy pains with the yacht.
Dunno, I think the policy was enabled, all myths and
I am trying to update a small table from a remote table with sqlplus
9.2.0.2 .
It seems to indicate that it has inserted 233 row into my local table -
howeverthat doesn't really happen.
Am I suffering from a severe lack of caffine oris this really
odd?
SQL select count(*) from facility;
recipients of list ORACLE-L [EMAIL PROTECTED]
|
| cc:
|
| Subject: SQLplus question unusual behavior
is not the same as CREATE TABLE facility.
HTH.
Arup
From: John Shaw [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: SQLplus question unusual behavior
Date: Mon, 20 Jan 2003 07:30:45 -0800
MIME-Version: 1.0
Received: from newsfeed.cts.com
PROTECTED]
| |
cc:
| | Subject: SQLplus
question unusual
behavior
|
---|I
am trying to update a small table from a remote table with sqlplus9.2.0.2
.It seems to indicate that it has inserted
I wish it was
-but that's not the case here. [EMAIL PROTECTED]
01/20/03 11:19AM Check if there are two taables named FACILTY in
your database.As SYS, checkSELECT OWNER, Object_name,
Object_typeFROM DBA_OBJECTSWHERE UPPER(OBJECT_NAME) =
'FACILITY'Note the use of upper(). Someone might have
is not the same as CREATE TABLE facility.
HTH.
Arup
From: John Shaw [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: SQLplus question unusual behavior
Date: Mon, 20 Jan 2003 07:30:45 -0800
MIME-Version: 1.0
Received: from
Chaim,
It was posted by John Shaw. And the figures showed 0 (not null) in the
original posting.
Arup
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: SQLplus question unusual behavior
Date: Mon, 20 Jan 2003 13:23
John Shaw wrote:
I am trying to update a small table from a remote table with sqlplus
9.2.0.2 .
It seems to indicate that it has inserted 233 row into my local table -
however that doesn't really happen.
Am I suffering from a severe lack of caffine or is this really odd?
SQL select count(*)
21, 2003 12:19 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: SQLplus question unusual behavior
Check if there are two taables named FACILTY in your database.
As SYS, check
SELECT OWNER, Object_name, Object_type
FROM DBA_OBJECTS
WHERE UPPER(OBJECT_NAME) = 'FACILITY
dictionary or your
program documentation.
Hope this helps.
Rgrds,
Sony
-Original Message-
From: Arup Nanda [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, January 21, 2003 12:19 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: SQLplus question unusual behavior
Check
15 matches
Mail list logo