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.org