novice learns a new thing

From: novicedba <novicedba_at_hotmail.com>
Date: Mon, 27 May 2002 00:28:20 -0800
Message-ID: <F001.0046BFEB.20020527002820@fatcity.com>

Hi all,
 I noticed something strange. Logically it makes sense but nevertheless strange. I don't know how to pur it in words.
So seniors please help

---

SQL> conn hlledw/hlledw_at_orcl9i
Connected.

SQL> grant select on edw_week_lvl to scott;

Grant succeeded.

SQL> grant select on edw_week_lvl to test1;

Grant succeeded.

SQL> conn scott/tiger_at_orcl9i
Connected.
SQL> desc hlledw.edw_week_lvl

 Name                            Null?    Type


 ------------------------------- -------- ----

 ID                              NOT NULL NUMBER(5)
 CODE                            NOT NULL VARCHAR2(16)
 DSC                             NOT NULL VARCHAR2(40)
 END_DATE                        NOT NULL DATE
 TIMESPAN                        NOT NULL NUMBER(3)

SQL> conn test1/test1_at_orcl9i
Connected.

SQL> desc hlledw.edw_week_lvl

 Name                            Null?    Type


 ------------------------------- -------- ----

 ID                              NOT NULL NUMBER(5)
 CODE                            NOT NULL VARCHAR2(16)
 DSC                             NOT NULL VARCHAR2(40)
 END_DATE                        NOT NULL DATE
 TIMESPAN                        NOT NULL NUMBER(3)

SQL> desc scott.edw_week_lvl
ERROR:
ORA-04043: object scott.edw_week_lvl does not exist

SQL> conn scott/tiger_at_orcl9i
Connected.
SQL> create synonym edw_week_lvl for hlledw.edw_week_lvl;

Synonym created.

SQL> desc edw_week_lvl

 Name                            Null?    Type


 ------------------------------- -------- ----

 ID                              NOT NULL NUMBER(5)
 CODE                            NOT NULL VARCHAR2(16)
 DSC                             NOT NULL VARCHAR2(40)
 END_DATE                        NOT NULL DATE
 TIMESPAN                        NOT NULL NUMBER(3)

SQL> conn test1/test1_at_orcl9i
Connected.
SQL> desc hlledw.edw_week_lvl

 Name                            Null?    Type


 ------------------------------- -------- ----

 ID                              NOT NULL NUMBER(5)
 CODE                            NOT NULL VARCHAR2(16)
 DSC                             NOT NULL VARCHAR2(40)
 END_DATE                        NOT NULL DATE
 TIMESPAN                        NOT NULL NUMBER(3)

SQL>  desc scott.edw_week_lvl
 Name                            Null?    Type


 ------------------------------- -------- ----

 ID                              NOT NULL NUMBER(5)
 CODE                            NOT NULL VARCHAR2(16)
 DSC                             NOT NULL VARCHAR2(40)
 END_DATE                        NOT NULL DATE
 TIMESPAN                        NOT NULL NUMBER(3)

SQL>

---

This is all strange to me
Coz
I am a novice DBA
Oracle Certifiable DBBS

An obstacle is something you see when you take your eyes off the goal -- Anonymous

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: novicedba
  INET: novicedba_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).

Received on Mon May 27 2002 - 03:28:20 CDT