| Kunal |
Posted: Jan 02, 2008 06:44:56 AM |
Total Post: 2
Joined: Jul, 2007
|
Hi,
I have a .dmp file placed in my c: and i wanted to use the "imp" utility to import it to a newly created 10g XE database.
I wrote the following lines on the SQL command prompt
SQL>connect system/oracle
SQL>imp system/oracle file=c:\master.dmp full=y log=imp.log
However this command fails and prompts an error SP2-734. (i tried the same on the web interface, and get the ora-900 error)
I guess, i am going wrong in accessing the path (c:\master.dmp).
Can anyone please advise me on the same.
Regards,
Kunal
|
|
|
 Mohammed Taj |
| Posted: Jan 02, 2008 07:19:55 AM |  |
|
Total Post: 746
Joined: Jul, 2007
|
your getting error message becuase your going wrong...
means "imp" is not in sqlplus command.
if you want to execute "imp" on sql prompt then you have to add before imp "host" command for execute oracle executable on sql prompt.
like
SQL>host imp_your_statement.
regards
Taj
|
|
|
|
|
| Kunal |
| Posted: Jan 02, 2008 07:27:04 AM | |
|
Total Post: 2
Joined: Jul, 2007
|
Thanks Taj,
That worked.. but out of curiosity i would like to ask you, that where should i have written the above line without "Host".
Thanks again..
|
|
|
|
|
| Mohammed Taj |
| Posted: Jan 02, 2008 08:27:46 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
On OS command prompt.
in windows.
c:\>
in linux
$
|
|
|
|
|
| ramesh |
| Posted: Jan 02, 2008 11:50:42 PM | |
|
Total Post: 77
Joined: Dec, 2006
|
Yes Kunal
in windows u hav to directly work on cmd prompt for oracle utilities like imp/exp, rman, ordim, lstcnr, etc...
and the syntax for imp goes like this
cmd prompt:\imp user/pwd@SID fromuser=user1 to user=user2 tables=tables1,tables2,tables3
Hope this will help u.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
