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
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'
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
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
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
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?
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
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?
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
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
---
DUMMY
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
11 matches
Mail list logo
