OraFAQ Forum: Forms » Import data through Form Developer

Home » Developer & Programmer » Forms » Import data through Form Developer (Oracle Developer Form, 6i, Server 2003)

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

Import data through Form Developer [message #535735]

Fri, 16 December 2011 01:27

hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN

Senior Member

Dear all

following is the coding i am using to run in forms 6i to import the data in oracle on When_Button_Press . it will drop and create a user but not importing the data some body can help me?

FORMS_DDL('DROP USER TEST CASCADE');
MESSAGE('USER DROP TEST');

FORMS_DDL('GRANT DBA TO TEST IDENTIFIED BY TEST');
MESSAGE('USER TEST CREATED');

host ('C:\oracle\ora90\BIN\IMP TEST/TEST IGNORE=y file=D:\ACC_INV\TEST.DMP');

MESSAGE('IMPORT');

EXIT_FORM;

Report message to a moderator

Re: Import data through Form Developer [message #535736 is a reply to message #535735]

Fri, 16 December 2011 01:30

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Quote:

it will drop and create a user

Where?

Report message to a moderator

Re: Import data through Form Developer [message #535870 is a reply to message #535736]

Fri, 16 December 2011 22:03

hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN

Senior Member

Thanx for Reply Little foot

i want to import the data in oracle database through form developer.
but i am not able to import the data the sql query that i already sent you, i am using for importing data through form Developer to Oracle database. can you please check the COding either there is any mistake?

The same sql query i am using to export the data by putting EXP in place of IMP that is working. but in case of import IMP command is not able to help me.
otherwise if you have any way to import the data through developer forms to Oracle database please tell me.

shafiq malik

Report message to a moderator

Re: Import data through Form Developer [message #535895 is a reply to message #535870]

Sat, 17 December 2011 04:08

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What I meant to say was: you never created that user, so - how can you expect to import any data to a non-existent user?

You:                         Should be:
- drop user test             - drop user test
- grant DBA to test          - CREATE USER TEST
- imp test/test              - grant certain privileges (why granting DBA? Are you sure you want to do that?)
                             - imp test/test

Report message to a moderator

Re: Import data through Form Developer [message #535899 is a reply to message #535895]

Sat, 17 December 2011 04:24

hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN

Senior Member

Still it is unable to import DMP file to oracle. i have used CREATE USER SYNTAX as well.

shafiq

Report message to a moderator

Re: Import data through Form Developer [message #535904 is a reply to message #535899]

Sat, 17 December 2011 05:04

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

Senior Member

So drop, recreate and do the grants in the form, then see if you can run imp from the command line.

Report message to a moderator

Re: Import data through Form Developer [message #536004 is a reply to message #535904]

Sun, 18 December 2011 22:04

hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN

Senior Member

i have tried to use import command through CMD but it was not executing, now i got it when i run the same form on server where oracle server is insalled. it is working well.

thanx all of you for giving kind support.

best regards,

shafiq malik

Report message to a moderator

Previous Topic:	forms problem (3 threads merged by bb)
Next Topic:	Error using ORA_FFI Forms 11g 64bit

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 26 00:27:03 CDT 2024