Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Table size and dates

  
   Database Help (Home) -> Oracle -> Server RSS
Next:  Order By Dimension Members  
Author Message
pavunkumar

External


Since: Mar 17, 2009
Posts: 1



(Msg. 1) Posted: Tue Mar 17, 2009 2:55 am
Post subject: Table size and dates
Archived from groups: comp>databases>oracle>server (more info?)
Dear Friend

How can we find the size and creation date of the
particular table
Thanks

 >> Stay informed about: Table size and dates 
Back to top
Login to vote
gareth

External


Since: Nov 30, 2005
Posts: 3



(Msg. 2) Posted: Tue Mar 17, 2009 3:37 am
Post subject: Re: Table size and dates [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On 17 Mar, 09:55, pavunkumar wrote:
> Dear Friend
>
>               How can we find the size and creation date of the
> particular table
> Thanks

DBA_SEGMENTS - http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statvie...4097.ht

DBA_OBJECTS - http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statvie...2005.ht

HTH

-g

 >> Stay informed about: Table size and dates 
Back to top
Login to vote
Mladen Gogala

External


Since: Jul 30, 2008
Posts: 67



(Msg. 3) Posted: Tue Mar 17, 2009 12:25 pm
Post subject: Re: Table size and dates [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Tue, 17 Mar 2009 02:55:48 -0700, pavunkumar wrote:

> Dear Friend
>
> How can we find the size and creation date of the
> particular table
> Thanks

By querying the data dictionary.



--
http://mgogala.freehostia.com
 >> Stay informed about: Table size and dates 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
comparing dates - Hi this is an inusual behavior for me, i have the next: SELECT (TO_CHAR(vPMM_DATETIME, 'YYYY-MM-DD') || ' 00:00:00') INTO vINIT_DATE FROM DUAL; SELECT (TO_CHAR(vPMM_DATETIME, 'YYYY-MM-DD') || ' 00:04:59') INTO vEND_DATE FROM DUAL; vFLAG := 0; LOOP IF....

populating a date field with random dates - I have a table that is populated with data for the month of June, I need to add roughly an equal number of rows to the table, but with the dates in the month of May. I can do an insert into table_a select field1,field2..date_field-30..field6 from..

any info on dates when oracle 11g patchset may be arriving? - I didn't find anything on metalink but maybe was distracted? Curious as to when oracle may or will start shipping a patchset for 11g database especially on 64 bit linux. Thanks in advance.

ASM I/O size - Hello, I'm running under 10.2 database on AIX5.3L I have disk group ASM_DATA which has 100 SAN equi-sized (256GB) disks/ luns. with MBRC of 16 & Block size of 16K , When I read a table of 10GB via FTS, what should be my I/O size/lun ? Should my I/O ...

PGA size and server process - Hi, I am now using dedicated server connection and I set pga_aggregate_target=1G. I find that there are total 5 server processes running by "ps -ef | grep oracle$SID" Does it mean that each server process can consume up to 1G so that the tota...
   Database Help (Home) -> Oracle -> Server All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]