No question at this time
DBA Top 10
1 B. Vroman 15700
2 M. Cadot 10200
3 T. Boles 8350
4 J. Schnackenberg 8300
5 A. Kavsek 7800
6 M. Hidayathullah ... 2500
7 P. Wisse 1200
8 G. Lambregts 1100
9 T. P 1000
10 B. Derous 500
10 R. Pattyn 500
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48277
Total active users1612
Act. users last 24h4
Act. users last hour0
Registered user hits last week185
Registered user hits last month836
Go up

ORA-38818: illegal reference to editioned object GOWNER.OM_MOVE_TYPE
Next thread: Oracle 18c standalone database still available?
Prev thread: RAC standby database for non-rac primary database (single instance)

Message Score Author Date
Dear All, I am trying to create an index based ...... Dev Rishi Trehan May 14, 2018, 08:14
Small correction. I am trying to create functio...... Dev Rishi Trehan May 14, 2018, 08:15
Hi, you want index in schema GLOGOWNER. You ha...... Ales Kavsek May 14, 2018, 17:08
ALTER SESSION SET EDITION = ora$base; OUTPUT: ...... javed akhtar May 15, 2018, 10:40

Follow up by mail Click here


Subject: ORA-38818: illegal reference to editioned object GOWNER.OM_MOVE_TYPE
Author: Dev Rishi Trehan, India
Date: May 14, 2018, 08:14, 160 days ago
Os info: Linux
Oracle info: Release 12.1.0.2.0
Message: Dear All,

I am trying to create an index based index on edition enabled database.

Under GLOGOWNER schema

CREATE INDEX "GLOGOWNER"."IX_OM_PLANNING_EDD" ON "GLOGOWNER"."ORDER_MOVEMENT_T" ("SOURCE_LOCATION_GID", "GOWNER"."OM_MOVE_TYPE"("ORDER_MOVEMENT_GID","ORIGINAL_LEG_GID"), "EARLY_DELIVERY_DATE")
PCTFREE 10 INITRANS 2 MAXTRANS 162 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "INDX" ;

I am getting this error

ORA-38818: illegal reference to editioned object GOWNER.OM_MOVE_TYPE

Function in GOWNER schema

create or replace function om_move_type(p_om_gid varchar2, p_original_leg_gid varchar2) return varchar2 deterministic as
v_move_type varchar2(4000);

begin
if p_original_leg_gid like 'GOWNER.UNIT%' then
v_move_type := 'UNITIZING_PLAN';
elsif p_om_gid like 'GOWNER.CNT%' or p_om_gid like 'GOWNER.CAO/_CNT%' escape '/' then
v_move_type := 'UNIT_MOVEMENT';
else
v_move_type := 'LOOSE';
end if;
return v_move_type;
end;

I can not change the database to NON EDITION.

Please guide if I need to change the function script or index script.
Thanks,
Dev
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: ORA-38818: illegal reference to editioned object GOWNER.OM_MOVE_TYPE
Author: Dev Rishi Trehan, India
Date: May 14, 2018, 08:15, 160 days ago
Message: Small correction.

I am trying to create function based index.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: ORA-38818: illegal reference to editioned object GOWNER.OM_MOVE_TYPE
Author: Ales Kavsek, Slovenia
Date: May 14, 2018, 17:08, 160 days ago
Message: Hi,

you want index in schema GLOGOWNER.
You have function for FBI in schema GOWNER.

My speculation is that your schema GOWNER is edition enabled and GLOGOWNER is not.

Regards,
Ales

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: ORA-38818: illegal reference to editioned object GOWNER.OM_MOVE_TYPE
Author: javed akhtar, India
Date: May 15, 2018, 10:40, 159 days ago
Message: ALTER SESSION SET EDITION = ora$base;

OUTPUT:
Table created.
Function created.
Index created.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here