Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: import made my objects case-sensitive
mRangel wrote:
> Dear friends,
>
> I did a full export from a 10.2.0.1.0 instance under Windows and
> imported (also full) to a 10.2.0.3.0 instance under Linux RHEL.
> Something happened to my pl/sql objects, and I do not know how to
> revert it. Take a look:
>
> First Database:
>
> SQL> select text from all_source where owner = 'PA' and line = 1 and
> text like 'PACKAGE%' order by text
> 2 /
>
> TEXT
> --------------------------------------------------------------------------------
> PACKAGE calendar IS
> PACKAGE Conversion_De_Moneda IS
> PACKAGE Formula2 IS
> PACKAGE Formula3 IS
> PACKAGE kp__arquit_utils AUTHID CURRENT_USER IS
> PACKAGE LD_API AUTHID CURRENT_USER IS
> PACKAGE ld_util AUTHID CURRENT_USER
> PACKAGE P2000_BASE64 IS
> (...)
>
> Second Database:
>
> SQL> select text from all_source where owner = 'PA' and line = 1 and
> text like 'PACKAGE%' order by text
> 2 /
>
> TEXT
> --------------------------------------------------------------------------------
> PACKAGE "CALENDAR" IS
> PACKAGE "CONVERSION_DE_MONEDA" Is
> PACKAGE "FORMULA2" IS
> PACKAGE "FORMULA3" IS
> PACKAGE "KP__ARQUIT_UTILS" AUTHID CURRENT_USER IS
> PACKAGE "LD_API" AUTHID CURRENT_USER IS
> PACKAGE "LD_UTIL" AUTHID CURRENT_USER
> PACKAGE "P2000_BASE64" IS
> (...)
>
> Does anybody know what happened ? Why did import double-quoted my
> object names ? Is there any way I can remove them ?
>
> Thanks,
Run dbms_metadata.get_ddl to get the DDL to recreate the objects.
Drop the originals
Alter the metadata
Rebuild them
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Tue Feb 06 2007 - 10:50:15 CST
![]() |
![]() |