Home » SQL & PL/SQL » SQL & PL/SQL » storage of tables
storage of tables [message #188554] Sat, 19 August 2006 09:24 Go to next message
Messages: 14
Registered: April 2006
Location: chennai
Junior Member


plz help me out

------from where user create tables and procedures storing

is it datadictionary tables
Re: storage of tables [message #188561 is a reply to message #188554] Sat, 19 August 2006 12:41 Go to previous message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
Tables,views,indexes,procedures etc..these are objects of the database.
datadictionary views contain information about database and its associated objects.
Query user_objects to know the objects you own.
Tables are stored in their respective tablespaces. These are just a way oracle chooses to display data. The actual data is stored in datafiles.
Previous Topic: Views
Next Topic: Converting a table to be a partition of a partitioned table
Goto Forum:

Current Time: Tue Oct 25 07:38:37 CDT 2016

Total time taken to generate the page: 0.12455 seconds