The oracle Import Utility is oracle database tool used to import users, database, tablesapces from database dump file. The utility can be invoked from the command prompt and also could be executed from windows Run mode. You could simply change the parameters and paste the command given below from windows Run mode. The log parameter maintains the log of the import.
IMP username/password FILE=file_path\filename.dmp FROMUSER=user_previously_dumped TOUSER=current_user ROWS=Y INDEXES=Y CONSTRAINTS=Y LOG=log_path_name\logfilename.txt
You can import the selected tables from the file with TABLES option
IMP username/password FILE=file_path\filename.dmp FROMUSER=user_previously_dumped TOUSER=current_user TABLES=BPT_SIGNATURES ROWS=Y INDEXES=Y CONSTRAINTS=Y LOG=log_path_name\logfilename.txt
No comments:
Post a Comment