Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2008
    Posts
    1

    Unanswered: ORA-00934: group function is not allowed here

    select o.owner ,o.object_name,o.object_type,S.TABLESPACE_NAME,t.l ast_analyzed,T.num_rows,sum(s.bytes/1024/1024),o.created,o.last_ddl_time,o.timestamp,
    o.status FROM dba_objects o ,dba_segments s,dba_tables t where o.owner=('SCOTT') and object_type='TABLE' and o.owner=s.owner and o.owner=t.owner group by sum(s.bytes/1024/1024),o.owner, o.object_name,S.TABLESPACE_NAME,T.last_analyzed,T. num_rows,o.created,o.last_ddl_time,o.timestamp,o.s tatus
    /

    I am getting the aboce error

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Thumbs down Fuchi-kk

    THIS IS NOT ALLOWED:
    Code:
    ...etc...
     group by sum(s.bytes/1024/1024),...etc...
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •