OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » application import/export failing, hopefully a simple one though

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » application import/export failing, hopefully a simple one though

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

application import/export failing, hopefully a simple one though [message #246586]

Thu, 21 June 2007 07:11

gina07
Messages: 1
Registered: June 2007

Junior Member

hi all,

i'm very new to oracle and am trying to get going with xe. i'm working between work and home and want to be able to transport wherever i'm at to work/home - so i thought the application import/export function would be the best way? first of all, is it?

if so - i keep getting the
failed to parse SQL query:
ORA-00942: table or view does not exist
error

i'm running the same versions of oracle, on the same platforms (Application Express 2.1.0.00.39, winXPpro all service packed up). both my users have dba roles and the apps work fine on the machines i created them on. the import and install processes claim to be successful and the error only comes up when i try to log in to the application. any ideas?

btw - the apps are just simple tests, dependences etc with a couple rows in each table]

any help be much appreciated even if its "go read this!" as i've googled away & got not much....

cheers!

Report message to a moderator

Re: application import/export failing, hopefully a simple one though [message #246762 is a reply to message #246586]

Thu, 21 June 2007 15:57

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

Senior Member
Account Moderator

In my opinion, yes - export and import utilities are to be used to transfer database between two computers.

As of ORA-00942 error: it appears at the moment of logging on to the application. Check whether there's a trigger which raises this error (trigger might be either in your application, a database trigger or both).

Report message to a moderator

Re: application import/export failing, hopefully a simple one though [message #247362 is a reply to message #246762]

Mon, 25 June 2007 12:18

andrew again
Messages: 2577
Registered: March 2000

Senior Member

ensure that both Database and Apex users are set up the same. In 2.1 the paths are:
Home>Administration>Manage Database Users
Home>Application Builder>Application Administration>Manage Application Express Users

Report message to a moderator

Previous Topic:	Retrieving remote user without owa package. Is it possible ?
Next Topic:	help with redirecting to next page

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 20:01:07 CST 2024