Results 1 to 3 of 3

Thread: Table's dbspace

  1. #1
    Join Date
    Sep 2003
    Posts
    11

    Unanswered: Table's dbspace

    Hi,

    Informix online - INFORMIX-SQL Version 5.10.UC2.

    How to find which dbspace the Table belongs.

    Thanks

  2. #2
    Join Date
    Aug 2003
    Location
    India
    Posts
    262

    Re: Table's dbspace

    Hi there,

    Foll is the query
    database sysmaster;
    select s2.name,s1.tabname,s1.owner from systabnames s1,sysdbspaces s2
    where s2.dbsnum=trunc(s1.partnum/1048576)
    and s1.owner='ocslinkdev'
    order by name,tabname,owner

    Regards,

    lloyd


    Originally posted by dbforumstest
    Hi,

    Informix online - INFORMIX-SQL Version 5.10.UC2.

    How to find which dbspace the Table belongs.

    Thanks

  3. #3
    Join Date
    Sep 2003
    Posts
    11
    Llyod,

    sysmaster database is not available on Informix online 5. Please where the tables on sql can be found.

    Thanks

Posting Permissions

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