Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Eliminate tables not longer used

2 posts in General Discussion Last posting was on 2009-06-05 20:22:35.0Z
Eve Posted on 2009-06-05 17:05:19.0Z
Sender: 606e.4a27f085.1804289383@sybase.com
From: Eve
Newsgroups: sybase.public.ase.general
Subject: Eliminate tables not longer used
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a29504f.10f8.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 5 Jun 2009 10:05:19 -0700
X-Trace: forums-1-dub 1244221519 10.22.241.41 (5 Jun 2009 10:05:19 -0700)
X-Original-Trace: 5 Jun 2009 10:05:19 -0700, 10.22.241.41
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:27821
Article PK: 77071

I have to administrate an old database that have many tables
created for temporary process that have to me delete from
database.

I want to know which tables don't be actualized recently for
eliminating them.

Any help.

P.D. Sorry for my english


Leonid Gvirtz Posted on 2009-06-05 20:22:35.0Z
From: Leonid Gvirtz <lgvirtz@yahoo.com>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Eliminate tables not longer used
References: <4a29504f.10f8.1681692777@sybase.com>
In-Reply-To: <4a29504f.10f8.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a297e8b$1@forums-1-dub>
Date: 5 Jun 2009 13:22:35 -0700
X-Trace: forums-1-dub 1244233355 10.22.241.152 (5 Jun 2009 13:22:35 -0700)
X-Original-Trace: 5 Jun 2009 13:22:35 -0700, vip152.sybase.com
Lines: 19
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:27823
Article PK: 77074

Hi

You can use monOpenObjectActivity monitoring table for this purpose. Check LastUsedDate and LastOptSelectDate fields to
see when table/index was used used last time.

Hope it helps
Leonid Gvirtz

Eve wrote:
> I have to administrate an old database that have many tables
> created for temporary process that have to me delete from
> database.
>
> I want to know which tables don't be actualized recently for
> eliminating them.
>
> Any help.
>
> P.D. Sorry for my english