Programming is my life~!
Tuesday, September 3, 2013
Oracle import dmp file
Step by Step
if not exist
1. create user {user_id} identified by {password}
2. GRANT CONNECT, DBA, RESOURCE TO {user_id};
$ imp {user_id}/{password} file={filename}.dmp ignore=y full=y
wow very Easy~
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment