Home » SQL & PL/SQL » 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))
Purpose of attached special Icon [message #648780] Thu, 03 March 2016 06:06 Go to next message
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/




[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 Go to previous messageGo to next message
Littlefoot
Messages: 21331
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';
Re: Purpose of attached special Icon [message #648785 is a reply to message #648780] Thu, 03 March 2016 06:20 Go to previous messageGo to next message
ThomasG
Messages: 3205
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...
Re: Purpose of attached special Icon [message #648788 is a reply to message #648780] Thu, 03 March 2016 09:12 Go to previous messageGo to next message
thatjeffsmith
Messages: 71
Registered: July 2009
Location: Raleigh, NC
Member

It means it's an IOT, Index Organized Table
Re: Purpose of attached special Icon [message #648940 is a reply to message #648788] Tue, 08 March 2016 03:00 Go to previous message
mokarem
Messages: 109
Registered: November 2013
Location: Dhaka
Senior Member

Thanks.

Yes, it is an IOT.

Previous Topic: Install Discoverer Viewer
Next Topic: UTL_FILE
Goto Forum:
  


Current Time: Fri Jan 19 18:26:34 CST 2018

Total time taken to generate the page: 0.02709 seconds