Re: duel error

2001-06-19 Thread Rocky Welch

Make sure you grant select from dual to public.

HTH,
-Rocky

--- Shirish Khapre [EMAIL PROTECTED] wrote:
 hi
 i accidentally  dropped duel table from sys..then recreated it.
 now when i am using rman during running the catrman.sql for
 recovery_catalog
 it is flashing error
 
 select '08.00.05' from dual
 *
 ERROR at line 2:
 ORA-00942: table or view does not exist
 
 u'r help is highly appreciated
 
 Shirish Khapre, SE Rolta India Ltd.
 Off Ph No. (+91) (022) 832,826,8300568
 Ext'n 2730
 Minds are like parachutes. They only function when they are open
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Shirish Khapre
   INET: [EMAIL PROTECTED]
 
 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: [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).


__
Do You Yahoo!?
Spot the hottest trends in music, movies, and more.
http://buzz.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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: [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).



Re: duel error

2001-06-19 Thread JOE TESTA




my guess is the public synonym is still there, grant select on dual to 
public.

if the synonym isnot there recreate it also.

joe
 [EMAIL PROTECTED] 06/19/01 01:51PM 
hii accidentally dropped duel table from sys..then 
recreated it.now when i am using rman during running the catrman.sql for 
recovery_catalogit is flashing errorselect '08.00.05' from 
dual*ERROR at line 2:ORA-00942: table or view does not 
existu'r help is highly appreciatedShirish Khapre, SE Rolta 
India Ltd.Off Ph No. (+91) (022) 832,826,8300568Ext'n 
2730Minds are like parachutes. They only function when they are 
open-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Shirish 
Khapre INET: [EMAIL PROTECTED]Fat City Network 
Services -- (858) 538-5051 FAX: (858) 538-5051San 
Diego, California -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from). You mayalso send the HELP command for 
other information (like subscribing).


Re: duel error

2001-06-19 Thread Ruth Gramolini

Who were you logged on as when you recreated it? Did you create a public
synonym for user.dual?  You should create the table as sys.dual and create
the public synonym for it. That should fix your problem

HTH,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, June 19, 2001 1:51 PM


 hi
 i accidentally  dropped duel table from sys..then recreated it.
 now when i am using rman during running the catrman.sql for
recovery_catalog
 it is flashing error

 select '08.00.05' from dual
 *
 ERROR at line 2:
 ORA-00942: table or view does not exist

 u'r help is highly appreciated

 Shirish Khapre, SE Rolta India Ltd.
 Off Ph No. (+91) (022) 832,826,8300568
 Ext'n 2730
 Minds are like parachutes. They only function when they are open

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Shirish Khapre
   INET: [EMAIL PROTECTED]

 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: [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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

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: [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).



Re: duel error

2001-06-19 Thread William Beilstein

And one more thing. The table dual has one column called dummy with is defined as 
varchar2(1). and contains ONE row with the value of 'X'.

 [EMAIL PROTECTED] 06/19/01 02:13PM 
Who were you logged on as when you recreated it? Did you create a public
synonym for user.dual?  You should create the table as sys.dual and create
the public synonym for it. That should fix your problem

HTH,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, June 19, 2001 1:51 PM


 hi
 i accidentally  dropped duel table from sys..then recreated it.
 now when i am using rman during running the catrman.sql for
recovery_catalog
 it is flashing error

 select '08.00.05' from dual
 *
 ERROR at line 2:
 ORA-00942: table or view does not exist

 u'r help is highly appreciated

 Shirish Khapre, SE Rolta India Ltd.
 Off Ph No. (+91) (022) 832,826,8300568
 Ext'n 2730
 Minds are like parachutes. They only function when they are open

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com 
 --
 Author: Shirish Khapre
   INET: [EMAIL PROTECTED] 

 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: [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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED] 

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: [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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Beilstein
  INET: [EMAIL PROTECTED]

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: [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).



RE: duel error

2001-06-19 Thread Kimberly Smith

You could always just run catalog.sql as sys.

-Original Message-
Sent: Tuesday, June 19, 2001 11:32 AM
To: Multiple recipients of list ORACLE-L


Your email says duel. You created dual, with an a, right?

And did you grant select on dual to public? And create a
public synonym for it?

HTH,

Yosi


Shirish Khapre wrote:

 hi
 i accidentally  dropped duel table from sys..then recreated it.
 now when i am using rman during running the catrman.sql for
recovery_catalog
 it is flashing error

 select '08.00.05' from dual
 *
 ERROR at line 2:
 ORA-00942: table or view does not exist

 u'r help is highly appreciated

 Shirish Khapre, SE Rolta India Ltd.
 Off Ph No. (+91) (022) 832,826,8300568
 Ext'n 2730
 Minds are like parachutes. They only function when they are open

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Shirish Khapre
   INET: [EMAIL PROTECTED]

 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: [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).

--
Thanks,

Yosi


-
Yosi Greenfield
Oracle Certified DBA
[EMAIL PROTECTED]


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yosi Greenfield
  INET: [EMAIL PROTECTED]

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: [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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  INET: [EMAIL PROTECTED]

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: [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).



RE: duel error

2001-06-19 Thread Kevin Lange

Did you remember the Grants and the Insert ??

create table dual   /* pl/sql's standard pckg requires dual.
*/
  (dummy varchar2(1))/* note, the optimizer knows sys.dual is single row
*/
  storage (initial 1)
/
insert into dual values('X')
/
create public synonym dual for dual
/
grant select on dual to public with grant option



-Original Message-
Sent: Tuesday, June 19, 2001 12:52 PM
To: Multiple recipients of list ORACLE-L


hi
i accidentally  dropped duel table from sys..then recreated it.
now when i am using rman during running the catrman.sql for recovery_catalog
it is flashing error

select '08.00.05' from dual
*
ERROR at line 2:
ORA-00942: table or view does not exist

u'r help is highly appreciated

Shirish Khapre, SE Rolta India Ltd.
Off Ph No. (+91) (022) 832,826,8300568
Ext'n 2730
Minds are like parachutes. They only function when they are open

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shirish Khapre
  INET: [EMAIL PROTECTED]

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: [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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

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: [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).



RE: duel error

2001-06-19 Thread Hal Wigoda

Dual is not a table.

It just a placeholder.

At 11:04 AM 6/19/01 -0800, you wrote:
You could always just run catalog.sql as sys.

-Original Message-
Sent: Tuesday, June 19, 2001 11:32 AM
To: Multiple recipients of list ORACLE-L


Your email says duel. You created dual, with an a, right?

And did you grant select on dual to public? And create a
public synonym for it?

HTH,

Yosi


Shirish Khapre wrote:

  hi
  i accidentally  dropped duel table from sys..then recreated it.
  now when i am using rman during running the catrman.sql for
recovery_catalog
  it is flashing error
 
  select '08.00.05' from dual
  *
  ERROR at line 2:
  ORA-00942: table or view does not exist
 
  u'r help is highly appreciated
 
  Shirish Khapre, SE Rolta India Ltd.
  Off Ph No. (+91) (022) 832,826,8300568
  Ext'n 2730
  Minds are like parachutes. They only function when they are open
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Shirish Khapre
INET: [EMAIL PROTECTED]
 
  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: [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).

--
Thanks,

Yosi


-
Yosi Greenfield
Oracle Certified DBA
[EMAIL PROTECTED]


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yosi Greenfield
   INET: [EMAIL PROTECTED]

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: [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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kimberly Smith
   INET: [EMAIL PROTECTED]

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: [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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hal Wigoda
  INET: [EMAIL PROTECTED]

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: [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).



RE: duel error

2001-06-19 Thread William Beilstein

Wrong, DUAL is a table owner by the SYS user that contains one row. Check your 
DBA_TABLES and DBA_OBJECTS views.

 [EMAIL PROTECTED] 06/19/01 03:56PM 
Dual is not a table.

It just a placeholder.

At 11:04 AM 6/19/01 -0800, you wrote:
You could always just run catalog.sql as sys.

-Original Message-
Sent: Tuesday, June 19, 2001 11:32 AM
To: Multiple recipients of list ORACLE-L


Your email says duel. You created dual, with an a, right?

And did you grant select on dual to public? And create a
public synonym for it?

HTH,

Yosi


Shirish Khapre wrote:

  hi
  i accidentally  dropped duel table from sys..then recreated it.
  now when i am using rman during running the catrman.sql for
recovery_catalog
  it is flashing error
 
  select '08.00.05' from dual
  *
  ERROR at line 2:
  ORA-00942: table or view does not exist
 
  u'r help is highly appreciated
 
  Shirish Khapre, SE Rolta India Ltd.
  Off Ph No. (+91) (022) 832,826,8300568
  Ext'n 2730
  Minds are like parachutes. They only function when they are open
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com 
  --
  Author: Shirish Khapre
INET: [EMAIL PROTECTED] 
 
  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: [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).

--
Thanks,

Yosi


-
Yosi Greenfield
Oracle Certified DBA
[EMAIL PROTECTED] 


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Yosi Greenfield
   INET: [EMAIL PROTECTED] 

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: [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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Kimberly Smith
   INET: [EMAIL PROTECTED] 

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: [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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Hal Wigoda
  INET: [EMAIL PROTECTED] 

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: [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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Beilstein
  INET: [EMAIL PROTECTED]

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: [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).



RE: duel error

2001-06-19 Thread lhoska

I think Dual is a table.

  1  SELECT TABLE_NAME FROM SYS.DBA_TABLES
  2* WHERE TABLE_NAME='DUAL'
SQL /

TABLE_NAME
--
DUAL

SQL DESC DUAL
 NameNull?Type
 ---  
 DUMMYVARCHAR2(1)


-Original Message-
Sent: Tuesday, June 19, 2001 3:56 PM
To: Multiple recipients of list ORACLE-L


Dual is not a table.

It just a placeholder.

At 11:04 AM 6/19/01 -0800, you wrote:
You could always just run catalog.sql as sys.

-Original Message-
Sent: Tuesday, June 19, 2001 11:32 AM
To: Multiple recipients of list ORACLE-L


Your email says duel. You created dual, with an a, right?

And did you grant select on dual to public? And create a
public synonym for it?

HTH,

Yosi


Shirish Khapre wrote:

  hi
  i accidentally  dropped duel table from sys..then recreated it.
  now when i am using rman during running the catrman.sql for
recovery_catalog
  it is flashing error
 
  select '08.00.05' from dual
  *
  ERROR at line 2:
  ORA-00942: table or view does not exist
 
  u'r help is highly appreciated
 
  Shirish Khapre, SE Rolta India Ltd.
  Off Ph No. (+91) (022) 832,826,8300568
  Ext'n 2730
  Minds are like parachutes. They only function when they are open
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Shirish Khapre
INET: [EMAIL PROTECTED]
 
  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: [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).

--
Thanks,

Yosi


-
Yosi Greenfield
Oracle Certified DBA
[EMAIL PROTECTED]


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yosi Greenfield
   INET: [EMAIL PROTECTED]

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: [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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kimberly Smith
   INET: [EMAIL PROTECTED]

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: [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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hal Wigoda
  INET: [EMAIL PROTECTED]

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: [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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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: [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).



RE: duel error

2001-06-19 Thread Mercadante, Thomas F

Uh Hal,

You should read the books.  Dual is a table.
And whoever suggested to re-run catalog was not quite correct.
Dual is created in the sql.bsq file.

the actual script says:

===  from sql.bsq   ===

create table dual   /* pl/sql's standard pckg requires dual.
*/
  (dummy varchar2(1))/* note, the optimizer knows sys.dual is single row
*/
  storage (initial 1)
/
insert into dual values('X')
/
create public synonym dual for dual
/
grant select on dual to public with grant option

===  from sql.bsq   ===

there!  I did my research for the day!  :)

Tom Mercadante




-Original Message-
Sent: Tuesday, June 19, 2001 3:56 PM
To: Multiple recipients of list ORACLE-L


Dual is not a table.

It just a placeholder.

At 11:04 AM 6/19/01 -0800, you wrote:
You could always just run catalog.sql as sys.

-Original Message-
Sent: Tuesday, June 19, 2001 11:32 AM
To: Multiple recipients of list ORACLE-L


Your email says duel. You created dual, with an a, right?

And did you grant select on dual to public? And create a
public synonym for it?

HTH,

Yosi


Shirish Khapre wrote:

  hi
  i accidentally  dropped duel table from sys..then recreated it.
  now when i am using rman during running the catrman.sql for
recovery_catalog
  it is flashing error
 
  select '08.00.05' from dual
  *
  ERROR at line 2:
  ORA-00942: table or view does not exist
 
  u'r help is highly appreciated
 
  Shirish Khapre, SE Rolta India Ltd.
  Off Ph No. (+91) (022) 832,826,8300568
  Ext'n 2730
  Minds are like parachutes. They only function when they are open
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Shirish Khapre
INET: [EMAIL PROTECTED]
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

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: [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).