Step-stepnya sbb:
1. connect sys as sysdba
2. drop user <nama_user> cascade;
3. create user <nama_user> identified by <password>
default tablespace <nama_tablespace>
temporary tablespace <nama_temp_tablespace>;
4.grant connect,resource to <nama_user>;
5. Import deh...
wkus77
<[EMAIL PROTECTED] To:
[email protected]
> cc:
Sent by: Subject: [indo-oracle] export
import
[EMAIL PROTECTED]
groups.com
18/05/2005 08:58
AM
Please respond to
indo-oracle
halo rekan-rekan
saya punya masalah. saya ingin mengcopy database 1 ke
database 2 tiap hari. masalahnya kedua database tsb
ada di 2 tempat yang berjauhan dan company ga mo
invest cisco. jadi tiap hari ada orang yang copy
database 1 ke database 2. nah kalo masalah import khan
biasa. tapi di database 2 khan data/tabelnya khan
harus didrop dulu. gmn caranya buat script drop table
yang ada di database 2 trus import data dari database
1
atao ada ide yang lebih baik????
terima kasih sebelumnya...
widhi
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
-----------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
--
-----------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/
