It's a
table.
>>> [EMAIL PROTECTED] 01/20/03 11:04AM
>>>
Just a thought - is facility a table or is it some
synonym/view pointing
somewhere
else..
Babu
|---------+------------------------------->
|
| John
Shaw
|
|
|
<John.Shaw@correctio|
|
|
nscorp.com>
|
|
| Sent
by:
|
|
|
[EMAIL PROTECTED]
|
|
|
|
|
|
|
|
| 01/20/03 10:30
AM |
|
| Please respond
to |
|
|
ORACLE-L
|
|
|
|
|---------+------------------------------->
>-----------------------------------------------------------------------------------------------------------|
|
|
|
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
|
|
cc:
|
| Subject: 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 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;
COUNT(*)
----------
0
SQL> insert into facility (select * from facility@dev);
233
rows created.
SQL> select count(*) from facility;
COUNT(*)
----------
0
SQL> commit;
Commit complete.
SQL> select count(*)
from facility;
COUNT(*)
----------
0
_____________
This e-mail transmission and any attachments to it
are intended solely for
the use of the individual or entity to whom it is
addressed and may contain
confidential and privileged information. If
you are not the intended
recipient, your use, forwarding, printing, storing,
disseminating,
distribution, or copying of this communication is
prohibited. If you
received this communication in error, please notify
the sender immediately
by replying to this message and delete it from your
computer.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network
Services -- 858-538-5051 http://www.fatcity.com
San Diego,
California -- Mailing list and web
hosting
services
---------------------------------------------------------------------
To
REMOVE yourself from this mailing list, send an E-Mail message
to:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message
BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list
you want to be removed from). You may
also send the HELP command for
other information (like subscribing).
- SQLplus question unusual behavior John Shaw
- Re: SQLplus question unusual behavior babu . nagarajan
- Re: SQLplus question unusual behavior Arup Nanda
- Re: SQLplus question unusual behavior John Shaw
- Re: SQLplus question unusual behavior John Shaw
- Re: SQLplus question unusual behavior Chaim . Katz
- Re: SQLplus question unusual behavior Arup Nanda
- Re: SQLplus question unusual behavior Vladimir Begun
- RE: SQLplus question unusual behavior Sony kristanto
- RE: SQLplus question unusual behavior Richard Ji
- RE: SQLplus question unusual behavior Harvey Neil
- Re: SQLplus question unusual behavior Arup Nanda
- RE: SQLplus question unusual behavior John Shaw
- Re: SQLplus question unusual behavior John Shaw