OraFAQ Forum: Client Tools » Purpose of attached special Icon

Home » Other » Client Tools » Purpose of attached special Icon (SQL Developer(Version 4.1..19), DB is XE Oracle 11g R2 , 64-bit Windows 7 Enterprise (Service Pack 1))

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

Purpose of attached special Icon [message #648780]

Thu, 03 March 2016 06:06

mokarem
Messages: 109
Registered: November 2013
Location: Dhaka

Senior Member

What does it denote the attached special icon of table in SQL Developer object navigator?

/forum/fa/13054/0/

Attachment: SpecialIcon.png
(Size: 16.38KB, Downloaded 3025 times)

[Updated on: Thu, 03 March 2016 06:07]

Report message to a moderator

Re: Purpose of attached special Icon [message #648784 is a reply to message #648780]

Thu, 03 March 2016 06:17

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I wouldn't know; what does the following query return when you run it?

select object_type from user_objects where object_name = 'COUNTRIES';

Report message to a moderator

Re: Purpose of attached special Icon [message #648785 is a reply to message #648780]

Thu, 03 March 2016 06:20

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

I would do a

SELECT * FROM all_tables 
 WHERE table_name IN ('COUNTRIES','DEPARTMENS','APP3','LOAD_ZINFRO_DOT')

and see if there are any differences...

Report message to a moderator

Re: Purpose of attached special Icon [message #648788 is a reply to message #648780]

Thu, 03 March 2016 09:12

thatjeffsmith
Messages: 81
Registered: July 2009
Location: Raleigh, NC

Member

It means it's an IOT, Index Organized Table

Report message to a moderator

Re: Purpose of attached special Icon [message #648940 is a reply to message #648788]

Tue, 08 March 2016 03:00

mokarem
Messages: 109
Registered: November 2013
Location: Dhaka

Senior Member

Thanks.

Yes, it is an IOT.

Report message to a moderator

Previous Topic:	Install Discoverer Viewer
Next Topic:	UTL_FILE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 20:02:19 CST 2025