Home » RDBMS Server » Server Administration » System Table DUAL
System Table DUAL [message #208860] Tue, 12 December 2006 06:33 Go to next message
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
Re: System Table DUAL [message #208863 is a reply to message #208860] Tue, 12 December 2006 06:36 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You should never insert/update/delete/alter the dual table.
Re: System Table DUAL [message #208868 is a reply to message #208860] Tue, 12 December 2006 06:43 Go to previous messageGo to next message
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
Re: System Table DUAL [message #208929 is a reply to message #208860] Tue, 12 December 2006 11:17 Go to previous message
dba_blr
Messages: 43
Registered: December 2006
Member
Never try to play with SYS objects manually. It may corrupt your database.
Previous Topic: Regarding Data file size
Next Topic: Complete Backup Procedure for Oracle 9i
Goto Forum:
  


Current Time: Fri Dec 09 15:52:21 CST 2016

Total time taken to generate the page: 0.15053 seconds