No question at this time
DBA Top 10
1 A. Kavsek 12400
2 M. Cadot 7300
3 B. Vroman 6400
4 P. Wisse 5600
5 J. PĂ©ran 1900
6 . Lauri 1500
7 T. P 500
7 R. Pattyn 500
9 A. Chavan 300
9 D. Johnson 300
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48458
Total active users1487
Act. users last 24h2
Act. users last hour0
Registered user hits last week190
Registered user hits last month829
Go up

Expdp/impdp: type specification incomplete
Next thread: Downtime (duration) Upgrade from 11.2.0.3 to 12.2.0.1
Prev thread: Oracle data guard configuration oracle12cr2 RAC environment

Message Score Author Date
During the import some object type specifications ...... Mick Ring Aug 28, 2018, 11:25
Hello Mick, was the expdp session successful? C...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Bruno Vroman Aug 29, 2018, 10:12
Hi Bruno, > but unfortunately the first reply o...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Ales Kavsek Aug 29, 2018, 13:40
Hello Ales, OK, <I>"good news"</I> for 11.2 cut...... Bruno Vroman Aug 29, 2018, 14:54
Hi, Thank you for answering! The bug, you ment...... Mick Ring Aug 31, 2018, 08:03

Follow up by mail Click here


Subject: Expdp/impdp: type specification incomplete
Author: Mick Ring, Denmark
Date: Aug 28, 2018, 11:25, 467 days ago
Os info: Windows
Oracle info: 11.2.0.4
Error info: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:...
Message: During the import some object type specifications shows incomplete afterwards. They are like cut off...

When inspecting the code, the specifications ends like this:
col_xx number(10),

Where it should have ended like this:
col_xx number(10),
constructor function obj_xx return self as result,
map member function maptovarchar2 return varchar2,
member function logtovarchar2(p_add_spaces in number := 0) return clob
)
instantiable final
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Expdp/impdp: type specification incomplete
Author: Bruno Vroman, Belgium
Date: Aug 29, 2018, 10:12, 466 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hello Mick,

was the expdp session successful? Can it be that the dmp file has been damaged during transport from source to destination?

Searching a bit I see MOS Doc Id 1313767.1 Package body is INVALID after impdp that is related to a bug (supposed to be fixed in 11.2), maybe there is something similar hitting you...
I suggest to open a SR, but unfortunately the first reply of Oracle Support will probably be to ask you why you are still using an unsupported version...

As a workaround I guess that you can look for invalid objects in the destination and fetch the object definitions from the source to fix them.

Best regards,

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

Subject: Re: Expdp/impdp: type specification incomplete
Author: Ales Kavsek, Slovenia
Date: Aug 29, 2018, 13:40, 466 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hi Bruno,

> but unfortunately the first reply of Oracle Support will probably be to ask you why you are still using an unsupported version...

This is not correct. 11.2.0.4 is supported till the end of this year (MOS:742060.1).

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: Expdp/impdp: type specification incomplete
Author: Bruno Vroman, Belgium
Date: Aug 29, 2018, 14:54, 466 days ago
Message: Hello Ales,

OK, "good news" for 11.2 cutomers...
I was looking at an old document with "free ES for 11.2 end: mid 2017", but indeed the document states also "have a look at doc 742060.1 ;-)
-Well, we moved to 12.1 and are going to 12.2 pretty soon.

Best regards,

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

Subject: Re: Expdp/impdp: type specification incomplete
Author: Mick Ring, Denmark
Date: Aug 31, 2018, 08:03, 464 days ago
Message: Hi,

Thank you for answering!
The bug, you mention, seems to be related to huge objects, but this isn't the case here. The two object type specifications in case are no longer than 50 lines of code.
There are other docs reporting situations where PLS-103 arises after expdp/impdp, but I don't find any with similar characteristics. The object type specifications doesn't contain special characters or have any other visible specialities like long names or the like.
Both expdp and impdp seems to have succeeded without errors. I wasn't running them bot this is what I was told.
Fortunately the fix was simple by just adding the missing few lines and compile, but I don't know if I was just lucky that it only hit 2 objects instead of 20 or 50...

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