OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » System Table DUAL

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

System Table DUAL [message #208860]

Tue, 12 December 2006 06:33

deswal_sanjay
Messages: 4
Registered: May 2005
Location: Noida

Junior Member

Hi,
Can we delete record from 'DUAL' table. If yes, and we do select * from DUAL then what will be the output.

Regards,
sanjay

Report message to a moderator

Re: System Table DUAL [message #208863 is a reply to message #208860]

Tue, 12 December 2006 06:36

ebrian
Messages: 2794
Registered: April 2006

Senior Member

You should never insert/update/delete/alter the dual table.

Report message to a moderator

Re: System Table DUAL [message #208868 is a reply to message #208860]

Tue, 12 December 2006 06:43

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi,
dual is synonym for sys dual table.

1 select table_name, table_owner,synonym_name
2 from dba_synonyms
3* where synonym_name = 'DUAL'
4 /

TABLE_NAME TABLE_OWNER
------------------------------ ------------------------------
SYNONYM_NAME
------------------------------
DUAL SYS
DUAL

for except sys cann't delete dual table;
or all other user ( system, scott or every new created ) have access permission on dual table synonym dual.
and all other user not able to delete dual table.

SQL> conn scott/tiger
Connected.
SQL> delete from dual;
delete from dual
*
ERROR at line 1:
ORA-01031: insufficient privileges

SQL> conn system/oracle
Connected.
SQL> delete from dual;
delete from dual
*
ERROR at line 1:
ORA-01031: insufficient privileges

SQL> conn system/oracle
Connected.
SQL> drop table dual;
drop table dual
*
ERROR at line 1:
ORA-00942: table or view does not exist

hope this helps
Taj

Report message to a moderator

Re: System Table DUAL [message #208929 is a reply to message #208860]

Tue, 12 December 2006 11:17

dba_blr
Messages: 43
Registered: December 2006

Member

Never try to play with SYS objects manually. It may corrupt your database.

Report message to a moderator

Previous Topic:	Regarding Data file size
Next Topic:	Complete Backup Procedure for Oracle 9i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:49:26 CDT 2024