OraFAQ Forum: Forms » how to import dmp file from forms

Home » Developer & Programmer » Forms » how to import dmp file from forms

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to import dmp file from forms [message #676710]

Mon, 08 July 2019 03:45

alhakimy
Messages: 56
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 2213 times)

Report message to a moderator

Re: how to import dmp file from forms [message #676711 is a reply to message #676710]

Mon, 08 July 2019 08:27

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: how to import dmp file from forms [message #676712 is a reply to message #676711]

Mon, 08 July 2019 08:49

alhakimy
Messages: 56
Registered: December 2016

Member

What to do if

Report message to a moderator

Re: how to import dmp file from forms [message #676713 is a reply to message #676712]

Mon, 08 July 2019 08:52

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: how to import dmp file from forms [message #676714 is a reply to message #676713]

Mon, 08 July 2019 09:02

alhakimy
Messages: 56
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

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: how to import dmp file from forms [message #676716 is a reply to message #676715]

Mon, 08 July 2019 09:39

alhakimy
Messages: 56
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

Report message to a moderator

Re: how to import dmp file from forms [message #676717 is a reply to message #676716]

Mon, 08 July 2019 09:45

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: how to import dmp file from forms [message #676725 is a reply to message #676717]

Tue, 09 July 2019 09:30

alhakimy
Messages: 56
Registered: December 2016

Member

what's meaning that
Attachment a pic

Attachment: Untitled2.jpg
(Size: 74.51KB, Downloaded 2039 times)

Report message to a moderator

Re: how to import dmp file from forms [message #676726 is a reply to message #676725]

Tue, 09 July 2019 09:35

cookiemonster
Messages: 13961
Registered: September 2008
Location: Rainy Manchester

Senior Member

Copy and paste the text rather than post an image

Report message to a moderator

Re: how to import dmp file from forms [message #676727 is a reply to message #676726]

Tue, 09 July 2019 10:08

alhakimy
Messages: 56
Registered: December 2016

Member

ok

SCHEMAS = alhakimy
'SCHEMAS' is not recognized as an internal or external command,
operable program or batch file.

Report message to a moderator

Re: how to import dmp file from forms [message #676728 is a reply to message #676727]

Tue, 09 July 2019 10:34

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Seems you have a carriage return in your command string.

Report message to a moderator

Re: how to import dmp file from forms [message #676729 is a reply to message #676728]

Tue, 09 July 2019 10:52

alhakimy
Messages: 56
Registered: December 2016

Member

what is the carriage return

Report message to a moderator

Re: how to import dmp file from forms [message #676730 is a reply to message #676729]

Tue, 09 July 2019 12:16

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Report message to a moderator

Re: how to import dmp file from forms [message #676732 is a reply to message #676730]

Wed, 10 July 2019 00:36

alhakimy
Messages: 56
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

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: how to import dmp file from forms [message #676734 is a reply to message #676727]

Wed, 10 July 2019 03:04

cookiemonster
Messages: 13961
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

Report message to a moderator

Re: how to import dmp file from forms [message #676736 is a reply to message #676734]

Wed, 10 July 2019 09:33

alhakimy
Messages: 56
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

Report message to a moderator

Re: how to import dmp file from forms [message #676737 is a reply to message #676736]

Wed, 10 July 2019 10:50

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

alhakimy
Messages: 56
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

Report message to a moderator

Previous Topic:	FRM-92101: There was failure in the Forms Server during startup
Next Topic:	Image on the form for splash screen

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 01:08:49 CST 2024