Home » Developer & Programmer » Forms » how to import dmp file from forms
how to import dmp file from forms [message #676710] Mon, 08 July 2019 03:45 Go to next message
alhakimy
Messages: 43
Registered: December 2016
Member
hi all

I still try to work imp from forms but without benefit

If I use this code through cmd it works

HOST('cmd.exe /c C:\app\almadany\product\11.2.0\dbhome_1\BIN\imp.exe system/system2 file= d:\1234.dmp fromuser=test2 touser=test2');
or
 HOST('C:\app\almadany\product\11.2.0\dbhome_1\BIN\imp.exe test2/test2 file= '||:text_item5||' fromuser=test2 full=y');
or
 HOST('Imp test2/test2 File = '||:text_item5||' fromuser=test2 touser=test2 full=y');

But through Forms it does not work (black screen show and hide quickly)

Attachment pic from cmd
  • Attachment: Untitled.jpg
    (Size: 79.14KB, Downloaded 41 times)
Re: how to import dmp file from forms [message #676711 is a reply to message #676710] Mon, 08 July 2019 08:27 Go to previous messageGo to next message
BlackSwan
Messages: 26567
Registered: January 2009
Location: SoCal
Senior Member
I could be wrong, but I believe that some, many, most Oracle utilities need or depend upon ORACLE_HOME environmental variable to be properly set.
Re: how to import dmp file from forms [message #676712 is a reply to message #676711] Mon, 08 July 2019 08:49 Go to previous messageGo to next message
alhakimy
Messages: 43
Registered: December 2016
Member
What to do if
Re: how to import dmp file from forms [message #676713 is a reply to message #676712] Mon, 08 July 2019 08:52 Go to previous messageGo to next message
BlackSwan
Messages: 26567
Registered: January 2009
Location: SoCal
Senior Member
If you were so inclined, you could write a self-contained script which does the import & invoke it from Forms.
Re: how to import dmp file from forms [message #676714 is a reply to message #676713] Mon, 08 July 2019 09:02 Go to previous messageGo to next message
alhakimy
Messages: 43
Registered: December 2016
Member
But the script shows the password

and
Do i understand from your words that it can not work import screen through the form

[Updated on: Mon, 08 July 2019 09:08]

Report message to a moderator

Re: how to import dmp file from forms [message #676715 is a reply to message #676714] Mon, 08 July 2019 09:31 Go to previous messageGo to next message
BlackSwan
Messages: 26567
Registered: January 2009
Location: SoCal
Senior Member
One can pass argument(s) to script.

You have NOT shared with us the version of Forms that you are using.

I don't know why you are using obsoleted "imp" utility instead of impdp; which has its own API that does not need to involve the command line processor.
Re: how to import dmp file from forms [message #676716 is a reply to message #676715] Mon, 08 July 2019 09:39 Go to previous messageGo to next message
alhakimy
Messages: 43
Registered: December 2016
Member
i am use forms 10g and db 11g
and I do not know about impdb but i am looking for it
Re: how to import dmp file from forms [message #676717 is a reply to message #676716] Mon, 08 July 2019 09:45 Go to previous messageGo to next message
BlackSwan
Messages: 26567
Registered: January 2009
Location: SoCal
Senior Member
alhakimy wrote on Mon, 08 July 2019 07:39
i am use forms 10g and db 11g
and I do not know about impdb but i am looking for it

Consider to Read The Fine Manual below

https://docs.oracle.com/database/121/SUTIL/toc.htm
Re: how to import dmp file from forms [message #676725 is a reply to message #676717] Tue, 09 July 2019 09:30 Go to previous messageGo to next message
alhakimy
Messages: 43
Registered: December 2016
Member
what's meaning that
Attachment a pic
Re: how to import dmp file from forms [message #676726 is a reply to message #676725] Tue, 09 July 2019 09:35 Go to previous messageGo to next message
cookiemonster
Messages: 13642
Registered: September 2008
Location: Rainy Manchester
Senior Member
Copy and paste the text rather than post an image
Re: how to import dmp file from forms [message #676727 is a reply to message #676726] Tue, 09 July 2019 10:08 Go to previous messageGo to next message
alhakimy
Messages: 43
Registered: December 2016
Member
ok

SCHEMAS = alhakimy
'SCHEMAS' is not recognized as an internal or external command,
operable program or batch file.
Re: how to import dmp file from forms [message #676728 is a reply to message #676727] Tue, 09 July 2019 10:34 Go to previous messageGo to next message
Michel Cadot
Messages: 66475
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Seems you have a carriage return in your command string.

Re: how to import dmp file from forms [message #676729 is a reply to message #676728] Tue, 09 July 2019 10:52 Go to previous messageGo to next message
alhakimy
Messages: 43
Registered: December 2016
Member
what is the carriage return
Re: how to import dmp file from forms [message #676730 is a reply to message #676729] Tue, 09 July 2019 12:16 Go to previous messageGo to next message
Michel Cadot
Messages: 66475
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Or a "new line" character; CHR(10) or CHR(13) in Oracle PL/SQL.

Re: how to import dmp file from forms [message #676732 is a reply to message #676730] Wed, 10 July 2019 00:36 Go to previous messageGo to next message
alhakimy
Messages: 43
Registered: December 2016
Member
But I did not use anything of them

so what do I do

[Updated on: Wed, 10 July 2019 00:45]

Report message to a moderator

Re: how to import dmp file from forms [message #676733 is a reply to message #676732] Wed, 10 July 2019 02:10 Go to previous messageGo to next message
Michel Cadot
Messages: 66475
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

This is what DOS received: it received 2 lines, so 2 command for it.
Check again, your command line is fold.

Re: how to import dmp file from forms [message #676734 is a reply to message #676727] Wed, 10 July 2019 03:04 Go to previous messageGo to next message
cookiemonster
Messages: 13642
Registered: September 2008
Location: Rainy Manchester
Senior Member
alhakimy wrote on Tue, 09 July 2019 16:08
ok

SCHEMAS = alhakimy
'SCHEMAS' is not recognized as an internal or external command,
operable program or batch file.
You really need to include the full call to imp
Re: how to import dmp file from forms [message #676736 is a reply to message #676734] Wed, 10 July 2019 09:33 Go to previous messageGo to next message
alhakimy
Messages: 43
Registered: December 2016
Member
Thanks to all

The problem was Because the creation of the directory from the system user

Now I've created another directory from sys user and everything has been done

This for information
Re: how to import dmp file from forms [message #676737 is a reply to message #676736] Wed, 10 July 2019 10:50 Go to previous messageGo to next message
Michel Cadot
Messages: 66475
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

This can't be the origin of the problem you posted.
It does not matter who created the (Oracle) directory, the only thing that matters (at Oracle level) is that the Oracle user that executes expdp (which is NOT what you first posted: imp) has the read and write privileges on the (Oracle) directory.

[Updated on: Wed, 10 July 2019 10:51]

Report message to a moderator

Re: how to import dmp file from forms [message #676743 is a reply to message #676737] Thu, 11 July 2019 01:54 Go to previous message
alhakimy
Messages: 43
Registered: December 2016
Member
At the beginning of the topic I was asked about imp
Then Mr. BlackSwan told me about impdp
This topic changes in the middle to the new topic
When I've created a directory and exported the data
When the previous message came to me
Previous Topic: FRM-92101: There was failure in the Forms Server during startup
Next Topic: Image on the form for splash screen
Goto Forum:
  


Current Time: Tue Jul 23 03:56:45 CDT 2019