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(*) from facility;
s of list ORACLE-L <[EMAIL PROTECTED]>
|
| cc:
|
| Subject: SQLplus question u
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
| | Subject: SQLplus
question unusual
behavior
|
>---|I
am trying to update a small table from a remote table wit
the use of upper(). Someone might have defined the table
in lowercase using quotes.CREATE TABLE FACILITY is not the same as
CREATE TABLE "facility".HTH.Arup>From: "John Shaw"
<[EMAIL PROTECTED]>>Reply-To:
[EMAIL PROTECTED]>To: Multiple recipients of list ORACL
have defined the table in lowercase
using quotes.
CREATE TABLE FACILITY 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 PROTEC
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
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(*) f
: Tuesday, January 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 D
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
>
ILITY'
-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 ind
P:[EMAIL PROTECTED]]
> > Sent: Tuesday, January 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
&
as the table owner 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 ques
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
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 mysteri
15 matches
Mail list logo