![]() crate_drop_user.sql file drop user "USER" cascade ĬREATE TABLESPACE USER DATAFILE 'D:\ORA_DATA\ORA10\USER.ORA' SIZE 10M REUSE Looking at the error log, it seems you have not specified the directory, so Oracle tries to find the dmp file in the default directory (i.e., E:\app\Vensi\admin\oratest\dpdump\).Įither move the export file to the above path or create a directory object to pointing to the path where the dmp file is present and pass the object name to the impdp command above.Īll this peace of code put into *.bat file and run all at once: If it was exported using expdp, then start the import with impdp: impdp / directory = dumpfile =. Grant the rights: grant connect, create session, imp_full_database to ![]() If it was exported using exp and a full schema was exported, thenĬreate the user: create user identified by default tablespace quota unlimited on ![]() I don't understand how I can resolve this issue. (OS 2) The system cannot find the file specified.Īnd when I see in Windows Explorer DMP file(taken from Linux server) is showing as Crash dump file Unable to open dump file "E:\app\admin\oratest\dpdump\WB_PROD_F I have tried the import utility E: / >impdp system /tiger FILE =WB_PROD_FULL_20MAY11.dmpīut I'm getting error as invalid argument value ![]() I placed the dump and log file in E: drive How would I go about creating a database from a dump file? I do not have an existing database with the same structure on my system so it has to be complete with jobs, events, tables, and so on. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |