Home » Developer & Programmer » Forms » Problem with Importing a dmp file
Problem with Importing a dmp file [message #188568] Sat, 19 August 2006 17:12 Go to next message
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 Go to previous messageGo to next message
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!
Re: Problem with Importing a dmp file [message #191574 is a reply to message #188568] Thu, 07 September 2006 02:59 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
You should post questions like this in the 'Application Express & MOD_PLSQL' forum.

David
Re: Problem with Importing a dmp file [message #191592 is a reply to message #191574] Thu, 07 September 2006 03:50 Go to previous messageGo to next message
jowahl
Messages: 82
Registered: May 2006
Member
why posting in 'Application Express & MOD_PLSQL' forum?
finally it's a forms question ...
Re: Problem with Importing a dmp file [message #192102 is a reply to message #191592] Sun, 10 September 2006 23:29 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Sorry, the screen dump reminded more of Application Express than Forms Builder.

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


Current Time: Sat Dec 03 15:55:29 CST 2016

Total time taken to generate the page: 0.04396 seconds