Dear Thoriq,
berdasarkan pengalaman saya temporary tablespace tsb nggak bs kita
resize kalo sudah jadi teknik yang biasa digunakan adalah
- Create temporary tablespace baru mis temp2 maxsizenya batasin biar
nggak bengkak
- rubah temporary tablespace user2X database ke temporary tablespace
baru
- drop temporary tablespace lama
- selsai
semoga bermanfaat
Master of Mobility
> Halo senior Oracle....
> Bantu saya dong.
> Saya menggunakan Oracle 9.2.0.4 - (o/s redhat 7.3)
> Saya mau upgrade database sekaligus manage temporary tablespace (TEMP).
> Dimana tablespace tsbt sbg default temporary tablespace schema "user".
> kalo saya lihat di EM ada isinya. Sebelumnya saya buat cuma 1 datafile
> dan saya bikin autoextent, tapi jadi bengkak 1 datafile jadi 5 GB.
> Kemudian sudah saya bikin jadi manual extent, datafile yg besar tersebut
> sudah saya offlinekan sekarang. karena saya juga sudah buat lagi datafile
> untuk
> temporary tablespace tersebut.
> Nah sekarang, saya mau upgrade database ke 10.2.0.3 - (o/s centos 4.3)
> Cuma saya mau mengurangi besar datafile temporary tersebut di database yg
> baru.
> Ada yang bisa bantu?
> Rencana proses upgrade ini saya menggunakan 2 mesin yg setara.
> Bagaimana, sebaiknya tahapan-tahapan yg harus saya lakukan ?
> Thx,
> Thoriq
> [Non-text portions of this message have been removed]
>
> Messages in this topic (1) Reply (via web post) | Start a new
> topic
> Messages | Files | Photos
> --
> -----------I.N.D.O - O.R.A.C.L.E---------------
> Keluar: [EMAIL PROTECTED]
> Website: http://indo-oracle.blogspot.com
> Mirror: http://indooracle.wordpress.com
> -----------------------------------------------
> Bergabung dengan Indonesia Thin Client User Groups,
> Terminal Server, Citrix, New Moon Caneveral, di:
> http://indo-thin.blogspot.com
> Change settings via the Web (Yahoo! ID required)
> Change settings via email: Switch delivery to Daily Digest | Switch format
> to Traditional
> Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
> Recent Activity
> 14
> New Members
> Visit Your Group
> SPONSORED LINKS
> Thin client server Database marketing software Database
> management software Online database software Customer database
> software
> Yahoo! Finance
> It's Now Personal
> Guides, news,
> advice more.
> Yahoo! HotJobs
> Be Discovered!
> Employers find you
> Upload your resume
> New web site?
> Drive traffic now.
> Get your business
> on Yahoo! search.
> .
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
Mirror: http://indooracle.wordpress.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.blogspot.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/indo-oracle/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
