(no subject)

From: Tommy Pham <TPham_at_specialized.com>
Date: Mon, 24 Jul 2000 14:02:01 -0700
Message-Id: <10568.112803@fatcity.com>

Hi,

How do I get the name of the object(s) based on the error msgs. below? THX
TP

Connected.

old  20: where tablespace_name = '&3';
new  20: where tablespace_name = 'SHX';
old  36: TABLESPACE &3
new  36: TABLESPACE SHX
old  60: TABLESPACE &3
new  60: TABLESPACE SHX
old  85: TABLESPACE &3
new  85: TABLESPACE SHX
old 109: TABLESPACE &3
new 109: TABLESPACE SHX
old 133: TABLESPACE &3
new 133: TABLESPACE SHX
old 157: TABLESPACE &3
new 157: TABLESPACE SHX
old 181: TABLESPACE &3
new 181: TABLESPACE SHX
old 206: TABLESPACE &3
new 206: TABLESPACE SHX
old 232: TABLESPACE &3
new 232: TABLESPACE SHX
old 256: TABLESPACE &3
new 256: TABLESPACE SHX
old 280: TABLESPACE &3
new 280: TABLESPACE SHX
old 305: TABLESPACE &3
new 305: TABLESPACE SHX
old 331: TABLESPACE &3
new 331: TABLESPACE SHX
old 355: TABLESPACE &3
new 355: TABLESPACE SHX
old 380: TABLESPACE &3
new 380: TABLESPACE SHX
old 405: TABLESPACE &3
new 405: TABLESPACE SHX
old 429: TABLESPACE &3
new 429: TABLESPACE SHX
old 453: TABLESPACE &3
new 453: TABLESPACE SHX
old 477: TABLESPACE &3
new 477: TABLESPACE SHX
old 503: TABLESPACE &3
new 503: TABLESPACE SHX
old 527: TABLESPACE &3
new 527: TABLESPACE SHX
old 551: TABLESPACE &3
new 551: TABLESPACE SHX
old 575: TABLESPACE &3
new 575: TABLESPACE SHX
old 600: TABLESPACE &3
new 600: TABLESPACE SHX
old 626: TABLESPACE &3
new 626: TABLESPACE SHX
old 650: TABLESPACE &3
new 650: TABLESPACE SHX
old 674: TABLESPACE &3
new 674: TABLESPACE SHX
old 698: TABLESPACE &3
new 698: TABLESPACE SHX
old 723: TABLESPACE &3
new 723: TABLESPACE SHX
old 748: TABLESPACE &3
new 748: TABLESPACE SHX
old 773: TABLESPACE &3
new 773: TABLESPACE SHX
old 798: TABLESPACE &3
new 798: TABLESPACE SHX
old 824: TABLESPACE &3
new 824: TABLESPACE SHX
old 849: TABLESPACE &3
new 849: TABLESPACE SHX
old 874: TABLESPACE &3
new 874: TABLESPACE SHX
old 899: TABLESPACE &3
new 899: TABLESPACE SHX
old 924: TABLESPACE &3
new 924: TABLESPACE SHX
old 955: TABLESPACE &3
new 955: TABLESPACE SHX
old 981: TABLESPACE &3
new 981: TABLESPACE SHX

declare
*
ERROR at line 1:

ORA-00955: name is already used by an existing object
ORA-06512: at "SYS.DBMS_SYS_SQL", line 782
ORA-06512: at "SYS.DBMS_SQL", line 32
ORA-06512: at line 630




        ,--o         ,--o         ,--o          ,--o
      _-\_<_        _-\_<_       _-\_<_       _-\_<_  let's bike!!! 

Received on Mon Jul 24 2000 - 16:02:01 CDT