Teman teman
Saya coba dikit, tapi kira2 bener ga ya, Untuk masalah yg di utarakan sdr huda,saya kira bisa aja , Misalnya sekarang tablespacenya x ada di drive d, mau dipindah ke e: Langakanya, Connect dulu ke database as sysdba Trus alter database backup control file to trace as 'c:\controlfile.sql'; Kemudian shutdown database, Trus pindah table space x ke e Hbs itu create ulang control file berdasakan trace ctrlfile tadi, jangan lupa isi di dalam c:\controlfile.sql dirubah lokasi table spacenya Mudah2an bisa membantu, kalau cara ini menurut teman2 yg expert ga bener tlg dikoreksi ya Thx Henri FIF _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of dingin00hs Sent: Monday, July 18, 2005 1:31 AM To: [email protected] Subject: [indo-oracle] [ASK]pindah lokasi tablespace file to the point... bisa nggak ya pindah lokasi tablespace? drive C: yg kami pakai sudah hampir penuh. sy berencana memindahkan tablespace file ke drive lain. baru nambah hardisk nih... :) yg sekarang terpikir sih sy dump trus hapus user, create ulang tablespace, restore. tapi koq gimanaaa gitu. konfigurasi system yg ada : server IBM (lupa tipenya), OS Win2K Advanced Server, Oracle 9i Enterprise Ed, ada TOAD tools apa ya yg bisa sy pake? sy sudah nyoba ubek2 tools2 bawaan oracle & TOAD, masih belum ketemu. btw, kalo produk Microsoft, cari2 help kan ada MSDN. di oracle apa ya?? kalo sy ngintip ke help yg ikut terinstal isinya, yg sy tau, cuma penjelasan "How to use this tool" (CMIIW). nyari2/belajar PLSQL misalnya, selama ini nyonteknya ke file2 bawaan TOAD. alhamdulillah, masih teratasi. yg bawaan oracle blm ketemu. atau memang gak ada ya?? tapi kalo nyari2 info spt di atas misal,... ??? apa harus selalu ngenet ya?? terima kasih... salam, huda, beginner -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com _____ YAHOO! GROUPS LINKS * Visit your group "indo-oracle <http://groups.yahoo.com/group/indo-oracle> " on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> * Your use of Yahoo! Groups is subject to the Yahoo! <http://docs.yahoo.com/info/terms/> Terms of Service. _____ [Non-text portions of this message have been removed] -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> 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/
