OraFAQ Forum: Forms » Problem with Importing a dmp file

Home » Developer & Programmer » Forms » Problem with Importing a dmp file

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

Problem with Importing a dmp file [message #188568]

Sat, 19 August 2006 17:12

wouter81
Messages: 1
Registered: August 2006

Junior Member

Hello,

I am trying to import a dmp file to make an excercise.
I've tried and read manuals all day now it seems I still do something wrong

First, In the Enterprise Manager console, I create a new user (CREATE LIKE scott):

http://users.skynet.be/wouterjans/orcl/oracle03.JPG

Then I create a new Table: dummy with 2 fields: A en B (varchar2 and size10)

http://users.skynet.be/wouterjans/orcl/oracle04.JPG

After that, grant dba to the new user

grant dba to DEMO;

Then I Run CMD and go to the c:\oracle\ora92\BIN folder

http://users.skynet.be/wouterjans/orcl/oracle01.JPG

I import the dmp file (STAG3536.dmp)
and it says it succeed

http://users.skynet.be/wouterjans/orcl/oracle02.JPG

So normally its ok

Then I go to my Form builder and I open a new Form

When I try to run the data wizard now. I only see the "dummy" record I created before but I dont see the database from my imported file.

http://users.skynet.be/wouterjans/orcl/oracle05.JPG

Could anyone help me pls ??

Thanks in advance,

Wouter

[Updated on: Sat, 19 August 2006 17:14]

Report message to a moderator

Re: Problem with Importing a dmp file [message #188778 is a reply to message #188568]

Mon, 21 August 2006 11:35

jowahl
Messages: 82
Registered: May 2006

Member

i think everything is ok here.

on the posted screen (data block wizard) you can see your table DUMMY. in the left window there are the avalailable columns (a, b) and you have to select which columns should appear in the block of your form: pick them with ">" or ">>" for all columns.

in this screen you will NOT see any database values!

Report message to a moderator

Re: Problem with Importing a dmp file [message #191574 is a reply to message #188568]

Thu, 07 September 2006 02:59

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

You should post questions like this in the 'Application Express & MOD_PLSQL' forum.

David

Report message to a moderator

Re: Problem with Importing a dmp file [message #191592 is a reply to message #191574]

Thu, 07 September 2006 03:50

jowahl
Messages: 82
Registered: May 2006

Member

why posting in 'Application Express & MOD_PLSQL' forum?
finally it's a forms question ...

Report message to a moderator

Re: Problem with Importing a dmp file [message #192102 is a reply to message #191592]

Sun, 10 September 2006 23:29

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Sorry, the screen dump reminded more of Application Express than Forms Builder.

David

Report message to a moderator

Previous Topic:	Disabling a Current record in a multi record block
Next Topic:	LOGIN CODE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:20:43 CDT 2024