Performace svvaduz

Article View: ch.admin

Article #15386

#15386

From: Walter Stucki
Date: Fri, 25 Aug 2000 06:13

22 lines
1694 bytes

Sali Werner

Ich w�rde mal noch verifizieren, ob durch den Import die
Indexe wirklich im richtigen Tablespace angelegt werden.
Indexe sollte in OLA_TS00_INDX, Tabellen in
OLA_TS00_DATA liegen.

select owner, index_name, tablespace_name
from all_indexes
where owner in ('INV', 'IPA', 'IGP', 'T4F', 'TRP')
order by 1,2, 3;

select owner, table_name, tablespace_name
from all_tables
where owner in ('INV', 'IPA', 'IGP', 'T4F', 'TRP')
order by 1,2, 3;

Ich bin noch bis 9:15 im B�ro.

Gruss Walti
-------------------------------------------------
www.oekosoft.ch | www.web-home.ch | www.linkex.ch

Technical Details

Message-ID: <8o539u$e5o$1@bw107zhb.bluewin.ch>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-east!supernews.com!newsfeed.direct.ca!look.ca!newsfeed.online.be!newsfeed01.sul.t-online.de!t-online.de!newsrouter.chello.at!newsmaster-01.atnet.at!atnet.at!newsfeed-zh.ip-plus.net!news.ip-plus.net!news.bluewin.ch!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: GERMAN,ASCII
X-Google-Thread: 11008d,4328e75cba604252,start
X-Google-Attributes: gid11008d,public
X-Google-ArrivalTime: 2000-08-24 23:29:12 PST
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-east!supernews.com!newsfeed.direct.ca!look.ca!newsfeed.online.be!newsfeed01.sul.t-online.de!t-online.de!newsrouter.chello.at!newsmaster-01.atnet.at!atnet.at!newsfeed-zh.ip-plus.net!news.ip-plus.net!news.bluewin.ch!not-for-mail
From: "Walter Stucki" <wstucki@oekosoft.ch>
Newsgroups: ch.admin
Subject: Performace svvaduz
Date: Fri, 25 Aug 2000 08:13:14 +0200
Organization: Oekosoft
Lines: 25
Message-ID: <8o539u$e5o$1@bw107zhb.bluewin.ch>
Reply-To: "Walter Stucki" <wstucki@oekosoft.ch>
NNTP-Posting-Host: bw2-215pub148.bluewin.ch
X-Trace: bw107zhb.bluewin.ch 967184510 14520 213.3.215.148 (25 Aug 2000 06:21:50 GMT)
X-Complaints-To: newsmaster@bluewin.ch
NNTP-Posting-Date: 25 Aug 2000 06:21:50 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211