| help - exp [message #55071] |
Thu, 02 January 2003 01:29  |
shareef
Messages: 72
Registered: November 2002
|
Member |
|
|
hi guru's
i have one dought that, while we exprot, the procedure, trigger and packages are also will be exported or not. if yes
after sucessfully importing the dump file, it is not able to perform my application using the database. it says unhandel_exception error for some modules and trigger not found for some other modules.
any comments and explation is appricated.
thanx
|
|
|
|
| Re: help - exp [message #55074 is a reply to message #55071] |
Thu, 02 January 2003 02:48  |
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
|
Senior Member |
|
|
hi,
Export will definitely get the Procedures and triggers unless u mention the tables clause in the command..
also some times u get an Procedure / Trigger invalid errors...IF u are getting those errors..simply recompile the schema by saying
Exec dbms_utility.compile_schema('Schema name');
Please provide more info...regarding what exactly are the errors ....etc so that the likelyhood of getting an answer increases..
sai
|
|
|
|
| Re: help - exp [message #55077 is a reply to message #55071] |
Thu, 02 January 2003 02:53 |
Miki
Messages: 11
Registered: August 2000
|
Junior Member |
|
|
Check for INVALID objects.
select * from user_objects
where STATUS = 'INVALID'
and OBJECT_TYPE in ('PACKAGE','PROCEDURE','VIEW','PACKAGE BODY','TRIGGER','FUNCTION');
If any - recompile
|
|
|
|
| Re: help - exp [message #55084 is a reply to message #55071] |
Thu, 02 January 2003 05:03 |
Raja
Messages: 57
Registered: March 2000
|
Member |
|
|
Hi
Also always look for any dependencies for the object ur going to export especially with procedures and pckg.
the dict is USER_DEPENDENCIES
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
