thanks for you replies.

i did a select on ts$. this is the result:

TS# NAME
---------- ---------------
0 SYSTEM
1 RBS
2 TEMP
3 TOOLS
4 USERS
5 TBSTABTS
6 TBSTGETS
7 TBDTMPTS
8 TBDIDXTS
9 XP_TS
10 PATROLTS
15 TBPIDXTS
16 TBPLMSTS
17 TRTESTDB
18 TRTESTTS
11 TMPLMSTS
12 TBPPMSTS
13 TBPSECTS
14 TBPSTCTS

does the TS# have to be in sequence in the result? or is it ok that all the numbers from 0-18 are there?

the select count results are:

19 rows selected.
>select count(*) from ts$
COUNT(*)
----------
19
1 row selected.
>select count(*) from ts$ where ts# > -1
COUNT(*)
----------
18
1 row selected.