Import dumping file oracle

catatan biar inget……..🙂

sebelum import dump file, buat user dulu yg ingin dimport dan yg melakukan export pada oracle sebelumnya

create user user_yg_di_export identified by password

barulah kasih grant utk melakukan import pd user tsb

grant create table, create session, resource, connect to user_yg_di_export

barulah lakukan import di console / cmd

imp user_dgn_dba_access/password_user file=alamat_file fromuser=user_yg_di_eksport touser=user_yg_ingin_diimport

utk akses ke web oracleadminny utk oracle xe :

http://localhost:8080/apex

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: