Server Utilities :: IMP-00041 / Object Created With Compilation Warnings
Sep 1, 2010
Every quarterly, we export the data from DEEXTRA and import into INEXTRA user.This is not working after i made the changes 2 tables and views in DEEXTRA .
I added new columns to 2 tables and associated 2 views. After this change, my import process got failed, with message especially for those views. "IMP-00041: Warning: object created with compilation warnings"
before i change the tables, import process was working fine. My doubt is, views were created in INEXTRA before the tables in import functionality.
I had given the grants similary the other objects. I belive no problems with privilages.
Because of table changes the order of the objects in exporting got disturbed? like in the exporting functionality first views created then the table?or the order of the objects in importing got disturbed? like first views created and then tables?
View 5 Replies
ADVERTISEMENT
Jun 18, 2010
For the export and import I am doing teh following steps:
1.Export the tablse space from the test machine where the whole stack is created
exp system/password@orcl file="data/OracleDump/arsystem.dmp" OWNER="ARADMIN";
2.Following steps to import: These steps followed by installer before it imports the tablespace on the destination machine
•CREATE TEMPORARY TABLESPACE ARTMPSPC TEMPFILE '/data/ORACLE/DATABASES/ORCL/artmp' SIZE 250M REUSE AUTOEXTEND ON
•CREATE TABLESPACE ARSYSTEM DATAFILE '/data/ORACLE/DATABASES/ORCL/ARSys' SIZE 7000M REUSE AUTOEXTEND ON
[code]...
3. Import the tablespace on a different box
imp system/password@orcl1 file="/dump/arsystem.dmp" buffer=1024000 fromuser=aradmin touser=aradmin feedback=1000000 log="dump/arsystem.log"
I could see in teh log lot of IMP-00041: Warning: object created with compilation warnings
example:
IMP-00041: Warning: object created with compilation warnings
"CREATE FORCE VIEW "ARADMIN"."BMC_CORE_BMC_IMPACT" ("
""REQUESTID","SUBMITTER","CREATEDATE","ASSIGNEDTO","LASTMODIFIEDBY","MODIFIE"
"DDATE","STATUS","SHORTDESCRIPTION","CMDBROWLEVELSECURITY","INSTANCEID","CMD"
[code]...
View 8 Replies
View Related
Aug 6, 2013
I've compiled a package with warnings ON. Getting message SP2-0809: Package Body Created with Compilation Errors.When I checked the errors by issuing "Show Errors", it shows "No error".
SQL> ALTER PACKAGE PKG_ABC COMPILE PLSQL_WARNINGS = 'ENABLE:ALL';
SP2-0809: Package Body Created with Compilation Errors
SQL> SHOW ERRORS
No Errors
how to check errors for that, or oracle simply pointing that package might have performance issue.
View 8 Replies
View Related
Dec 6, 2012
When i do run export command through command prompt, its shows below error.
Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp.
C:Documents and SettingsAdministrator>Exp disdeva/disa123@distesta file=D:DAI LY_BACKUPdistesta.dmp log=D:DAILY_BACKUPdistesta.log statistics=none buffer=5 000000 owner=distesta
Export: Release 10.2.0.3.0 - Production on Thu Dec 6 15:06:21 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Release 10.2.0.3.0 - Production Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
About to export specified users ...
EXP-00010: DISTESTA is not a valid username Export terminated successfully with warnings.
C:Documents and SettingsAdministrator>
When i connect from sqlplus, it doesn't give any erro. What could be the reason?
SQL> conn disdeva/disa123@distesta
Connected.
SQL>
View 8 Replies
View Related
Jul 15, 2010
Whenever I create a table using login A, the table gets created successfully. But when I query the dba_objects, the object owner is different, login B. What might be the reason behind this?
View 9 Replies
View Related
Sep 23, 2010
I did an export from 8.1.7 and imported in 10g. All the tables were imported. I created all the users and gave them necessary grants. when i try to compile synonyms for this schema i imported,I get the following error in enterprise manager:
Failed to compile: ORA-00980: synonym translation is no longer valid
I cannot login to my application with these users even though they have all grants. I receive the following error:
FRM-40735:PRE-FORM trigger raised unhandled exception ORA-00942
When i click ok, the screen disappears.
View 11 Replies
View Related
Dec 13, 2010
I've build a simple trigger like this:
CREATE or REPLACE TRIGGER my_trigger
BEFORE UPDATE OF PASSWORD ON mytable
FOR EACH ROW
DECLARE
BEGIN
:NEW.PASSORD := 'xyzt';
EXCEPTION
WHEN OTHERS THEN
raise_application_error(-20001,'Error '|| sqlerrm);
END trigger_create_user;
But, when i execute it, i get the following message:Warning: Trigger created with compilation errors.Even if i do nothing in trigger body:
CREATE or REPLACE TRIGGER my_trigger
BEFORE UPDATE OF PASSWORD ON mytable
FOR EACH ROW
DECLARE
BEGIN
END trigger_create_user;
I still get that message.
View 7 Replies
View Related
Mar 8, 2012
CREATE OR REPLACE PACKAGE pkg_mkt_hub_load_collection
AS
PROCEDURE sp_final_load_mkt_hub;
END pkg_mkt_hub_load_collection;
/
CREATE OR REPLACE PACKAGE BODY pkg_mkt_hub_load_collection
AS
c_default_limit CONSTANT PLS_INTEGER:=5000;
[code]....
show error
error code
SQL> @pkg_mkt_hub_load_collection.sql
Package created.
Warning: Package Body created with compilation errors.
Errors for PACKAGE BODY PKG_MKT_HUB_LOAD_COLLECTION:
LINE/COL ERROR
-------- -----------------------------------------------------------------
57/4 PL/SQL: Statement ignored
PLS-00306: wrong number or types of arguments in call to 'MULTISET_INTERSECT_ALL'
SQL>
View 11 Replies
View Related
Jun 21, 2011
I created a view in DB2 .I copied the code of view from DB3 and created in DB1. The view got created but with compilation errors.
SQL>
SQL> CREATE OR REPLACE FORCE VIEW bala.cee_efacts_pie_order_v (cenumber,
2 installationid,
3 areanumber,
4 clli,
5 servicedate,
6 forecasttype,
7 jobid,
8 shippriority,
[code]....
I checked the status of view in user_objects , it was invalid.How to make it valid ?
View 11 Replies
View Related
Jun 6, 2012
I need a clarification on the below query:
1) DROP USER MK CASCADE;
2) Created user
3) Created objects like procedure,index... and granted privileges.
4) Now i am performing the import as below.
impdp system/.... SCHEMAS=MK DIRECTORY=EXPBKUP DUMPFILE=ABC_Export.dmp LOGFILE=ABC_imp.log INCLUDE=TABLE TABLE_EXISTS_ACTION=REPLACE
But nothing is imported.
Is this the problem of the parameter "INCLUDE=TABLE TABLE_EXISTS_ACTION=REPLACE"? as the user is new.
View 5 Replies
View Related
Nov 18, 2011
I have near 114 export.dmp.z* export backup. I am trying to import it on newly created database using imp.
But i am not getting how can i select all export.dmp.z* files using imp. Its easy in impdp, but i have exported backup.
View 7 Replies
View Related
Jan 2, 2012
As a part of our back up we used to export the production data every day using Original export Utility but from 11g original export Utility is de supported and also datapump doesn't support XML Objects so is there any other way to export the full database else any option to export xml Object using datapump.
View 2 Replies
View Related
Sep 19, 2010
I have 2 users (scott and Krishnan).
Krishnan wants to import the table, which was exported by scott.
1) but we should not run the script file of CATALOG.SQL.
2) we can't give the rights of imp_full_database from outside.
Also how user Krishnan can import that table to another user's schema?
View 3 Replies
View Related
Jul 22, 2011
I have 780(12*65) csv files generated from 65 databases.Now I have to load this 780 csv files into 12 tables created in my database for some monitoring and reporting purpose.to call the sql loader I am plannig to create 780 lines like below.
sqlldr abc@tns/pwd control='E:htmlctlhtml_broken_jobs_rpt.ctl' log='E:htmlreportloghtml_broken_jobs_rpt.log'
sqlldr abc@tns/pwd control='E:htmlctlhtml_db_size_rpt.ctl' log='E:htmlreportloghtml_db_size_rpt.log'
sqlldr abc@tns/pwd control='E:htmlctlhtml_fragmentation_rpt.ctl' log='E:htmlreportloghtml_fragmentation_rpt.log'
sqlldr abc@tns/pwd control='E:htmlctlhtml_index_stats_rpt.ctl' log='E:htmlreportloghtml_index_stats_rpt.log'
sqlldr abc@tns/pwd control='E:htmlctlhtml_invalid_object_rpt.ctl' log='E:htmlreportloghtml_invalid_object_rpt.log'
sqlldr abc@tns/pwd control='E:htmlctlhtml_long_running_queries_rpt.ctl' log='E:htmlreportloghtml_long_running_queries_rpt.log'
we know creating 780 control files is the difficult task.So I have created only 12 control files. is there any mechanism to pass a varible (planning to declare it in the sqlldr line) to the infile clause like below in sql loader?
infile "E:htmlreportoutput&a_html_broken_jobs_rpt.csv"
here a is the variable name. it will change every 12 csv files once.
or
is there anyother way to achive this?
View 8 Replies
View Related
Nov 12, 2012
Procedures, triggers and other object with character changed.
Every character was replaced by ã? the content of procedures and other objects after importing a schema for production approval.
Example:
EXCEPTION
WHEN OTHERS THEN
p_msgerro := p_msgerro ||
' Erro na selec?o da Unidade Administrativa. ' ||
The character (?) deveria ser (ã)
View 4 Replies
View Related
Sep 9, 2010
We want to import a dump in TESTIMP Schema:
D:>impdp TESTIMP/TESTIMP TABLES=ENVDB DIRECTORY=Rini DUMPFILE=envdb_11g.dmp REM
AP_SCHEMA=TESTIMP:STP11G REMAP_TABLESPACE=TBS_TESTIMP:TBS_STP11G;
Import: Release 11.2.0.1.0 - Production on Thu Sep 9 15:16:45 2010
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39166: Object TESTIMP.ENVDB was not found.
View 2 Replies
View Related
Apr 28, 2011
I am importing the dump.All the tables are getting imported but when it comes to the part as shown in the error it gets struck there and nothing is showed after.
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
The dumps for which I am doing the import is huge. Its around 46 GB.
select
sl.sid,
sl.serial#,
sl.sofar,
sl.totalwork
from
v$session_longops sl,
v$session s,
dba_datapump_sessions d
where
s.saddr = d.saddr
and s.sid = sl.sid
and s.serial# = sl.serial#
order by start_time;
It showing the lock for two sid's. Should I kill the process and import the dump again? I used below command to import dums
impdp sys/*****@dbname directory=dump_dir dumpfile=prod_dump_%U_200311 SCHEMAS=int_aaa int_bbb int_ccc int_ddd int_eee int_fff
int_ggg int_hhh int_iii int_jjj int_kkk int_lll
View 10 Replies
View Related
Nov 7, 2013
How to write and fire trigger if any database object will created?
View 1 Replies
View Related
Feb 14, 2013
Is there a way to find when was a database role created and who has created?
View 5 Replies
View Related
Jun 27, 2012
One of my friends is facing a peculiar problem where objects are getting "Invalid" during execution I suspect it is happening as they are changing system date during their testing (time travel) which can create conflicted last_ddl_time on objects having dependencies
Consider a scenario
[1] system date is 10-06-2012 there are total 10 objects which has status as 'valid'
[2] the system date is changed to 10-07-2012 Now out of 10 Only 5 objects are compiled During execution ORA-04065,ORA-06508, ORA-06512 are observed
[3] the system date is brought back to 10-06-2012 Again during execution ORA-04065,ORA-06508, ORA-06512 are observed
suppose in step 2 objects are compiled whereas there synonyms are compiled in step 1, only thus last_ddl_time for objects will be later to that of its' synonym...
Does database validate last_ddl_time for objects having dependency during execution and then auto-compiles or invalidates the objects?
View 3 Replies
View Related
Jul 26, 2012
I applied this patch in our development environment. After validation, I need to apply the same in production, training and publication environments. The detailed information follows :
PowerPC_POWER5 / aix 5300-12
OPatch utility used : 11.2.0.3.0
OUI version : 11.2.0.2.0
Prereq "checkConflictAgainstOHWithDetail" passed.
Composite patch 13923804 successfully applied.
OPatch Session completed with warnings.
Stderr output:
ld: 0711-224 WARNING: Duplicate symbol: p_xargc
ld: 0711-224 WARNING: Duplicate symbol: p_xargv
ld: 0711-224 WARNING: Duplicate symbol: .kghalf
ld: 0711-224 WARNING: Duplicate symbol: .kghalp
ld: 0711-224 WARNING: Duplicate symbol: .bcopy
ld: 0711-224 WARNING: Duplicate symbol: .kghgrw
ld: 0711-224 WARNING: Duplicate symbol: .kghfrf
[code]....
OPatch completed with warnings.
As they are harmless ? Whether I need to rollback ?
View 2 Replies
View Related
Sep 26, 2013
I have compiled some procedures, at the time of compilation i saw some warnings & errors but i did not notice, Now can we see that errors or warnings in db console or any other way.
View 7 Replies
View Related
Aug 17, 2012
tell me if a REFRESH GROUP is automatically created when a materialized view is created?
View 3 Replies
View Related
Apr 2, 2013
I have a Client Server application that I created using an MS-SQL Server Database (MS-SQL Server 2008 R2 Express).Since MS-SQL Server has wide range (and number) of DATA_TYPEs, I elected to dedicate a few of those DATA_TYPEs to application-specific processing (mainly the MONEY and BOOLEAN DATA_TYPES).
I further decided that within the Client Application that the general processing of a particular field would be determined by the corresponding DATA_TYPE stored in the database.
The DATA_TYPE of a particular field within the SQL Server database and may be determined by querying:
"select DATA_TYPE from INFORMATION_SCHEMA.Columns where ( ( Column_name = 'my_Field' ) and ( Table_Name = 'myTable' ) )"
I also extract/use other DATA_TYPE information as needed/appropriate.
With this information the Client Application can consistently process a MONEY (a DATA_TYPE in MS-SQL Server) differently than perhaps either a DECIMAL or a BIGINT (two other DATA_TYPEs in MS-SQL Server). I have to create the field with the correct DATA_TYPE in the database, but after that I don't have to worry about it.
I am now moving over to an Oracle Database (Oracle Database Express Edition 11g Release 2). And I would like to have the same (or similar) functionality as described above.
Oracle has fewer DATA_TYPES so it is more difficult to tie an application-specific-datatype to an Oracle-database-specific-DATA_TYPE. There simply aren't as many to "sacrifice" to my application-specific-processing. I don't want to treat every NUMERIC field as "the-apps-money-type."
With Oracle I can associate "the-apps-money-type" with, let's say, a NUMERIC(9,2) and then the Client Application will treat all NUMERIC(9,2) as "the-apps-money-type."The Client Application queries the Oracle database for DATA_TYPE, DATA_PRECISION, and DATA_SCALE to make this determination.
But this approach does not appeal to me, suppose that I have other NUMERIC(9,2) fields that are not of "the-apps-money-type." How can I set and then later determine, from the Oracle backend, if the NUMERIC(9,2) field is meant to be used as "the-apps-money-type" or just a regular number?
Is there some way I may create some sort of "sub DATA_TYPE" in Oracle?I considered indicating this in the COMMENTS field that is associated with particular field. Then query for that comment when I process NUMERIC DATA_TYPEs. But the COMMENTS field does not seem to make it into user_tab_columns or all_tab_columns.
(With Oracle SQL Developer one can create/modify/delete the user created tables/fields. COMMENTS may be added to particular fields within a table--these are the COMMENTS that I am referring to above).What I would like to do, and most direct approach to me, would be to somehow create a user defined DATA_TYPE that is simply:
1) a user defined DATA_TYPE name (like, MY_MONEY_TYPE),
2) associated with an Oracle Built-in datatype (like NUMERIC(9,2).
Then when the client application queries user_tab_columns the field may be processed appropriately. If I cannot do that, perhaps there is somewhere else that I may set and subsequently query for this sort of information. What is(are) the most direct way(s) to implement the functionality described above?
View 4 Replies
View Related
Sep 26, 2012
While practicing with Triggers, the following error was encountered. An Object Type and an object Table are created.
create or replace
type typPerson is object
(id number,
firstname varchar2(30),
lastname varchar2(30)
[code].........
I executed the below insert statement, and I got the following error.
SQL> insert into person_obj_tab values (10,'Object1','From Trigger');
insert into person_obj_tab values (10,'Object1','From Trigger')
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 4153
Session ID: 136 Serial number: 305
[code]......
SQL> insert into person_obj_tab values (10,'Object','Original');
1 row created.Question:
1) Trigger of version 1 did not report any error during compilation, but during DML execution, hangs for sometime and gives the above error.
2) Whether direct assignment of Objects of greater size is possible inside triggers built on object Tables?
3) Suppose an object contain multiple attributes (say more than 20), then how to assign them inside a trigger?
View 1 Replies
View Related
Jan 25, 2013
I have a problem with executing oracleCommand.ExecuteReader() method. Whatever I try it always returns null and it won't create OracleData reader object. I'm using ODAC 1120320_x64 for .net 4.0 and timesten112241.win64. Don't sure what to do. Debugger is showing strange thing in OracleConnection object : ConnectionState = Closed, but output of ttStatus shows connection to TimesTen data store and ExecuteNonQuery() command works just fine with or without (in or out) parameters. But when I try to execute some query with multile output such as select *, I can't get any result.
I also have a strange problem with connection.Open() When I execute Open() i throws AccessViolationException that can be handled with [Handle ProcessCorruptedStateExceptions] attribute, but connection is established after that and my application works fine until I try to instance OracleDataReader object.
Here is the code:
OracleCommand select = null;
OracleDataReader reader = null;
select = new OracleCommand(selectStmt, connection);
select.CommandType = CommandType.Text;
try
{
reader = select.ExecuteReader(); // this line throws NullReferenceException
if (reader.HasRows)
{
[code]....
Just to mention, I tried it with different queries (pl/sql, plane sql, stored procedure) and all of them works fine in SQL Developer, but not in app.
View 10 Replies
View Related
Apr 21, 2011
Using suppress triggers options in golden gate. I was trying to work on the same but it doesn't seem to work at least for me.
Scenario:
Database Version 11.2.0.2
GoldenGate v11
OS Windows
Created two databases on the same server with same schmea idea was to replicate change from one database to other. One of the tables in the source database had trigger(every insertion in the table would cause a row to be inserted into a diff table). if row was inserted in table A it will insert a new row in table B . the same records will pass on target but the trigger defined on table A should not trigger on target as it has already fired on Source .
I tried using suppresstriggers but it doesnt seem to work everytime the trigger is getting fired on target database.
CODEReplicat process
replicat repname
assumetargetdefs
userid gguser@bbb password Oracle
dboptions suppresstriggers
map x.* ,target x.* (since same schema)
The extract files,pump files and replication are working fine.I also used the dbms_goldengate_auth.grant_admin_privilege for gguser.
Also I noticed when I give the dboptions suppresstriggers replication process doesnt startup with unrecognised word message when i give dboptions suppress triggers the replicat process does start is this the way it should be.i have gone through the docs and it should be supresstriggers.
View 3 Replies
View Related
Feb 23, 2012
how to find the versions of exp and imp utilities of database server from windows command prompt?
Note: Currently i have 10.2.0.10 oracle software installed on my local machine.
View 4 Replies
View Related
Jan 16, 2012
i create new database (Student) using command line, now i want to connect with newly created database (using sys as sysdba), but again it directly connected with old database (ORCL). So what should i do to connect with newly created database (Student).
View 3 Replies
View Related
Feb 12, 2013
i can't re-create a datafile.
c:> sqlplus
Enter user-name: sys as sysdba
Enter password:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select name,ts# from v$tablespace;
NAME TS#
------------------------------ ----------
SYSTEM 0
SYSAUX 1
UNDOTBS1 2
USERS 4
TEMP 3
[code].....
why can't it create re-create the datafile even i dropped tablespace with its content and its datafiles?
View 7 Replies
View Related
