-
How to remove quotes from packages on import?
When we import from a production database, all packages and procedures have quotes around them, e.g.
select text from dba_source where name ='BILLINVOICE_TEMP';
PACKAGE "BILLINVOICE_TEMP" AS
We see this on production and the database we import to.
How do we import without these quotes? We also have a development database that doesn't have these quotes, e.g.
select text from dba_source where name ='BILLINVOICE_TEMP';
PACKAGE billinvoice_temp AS
Thanks.
-
they dont matter - you can ignore them
-
Hi, Thanks for the reply. Unfortunately it matters for our developers. When they do a comparison between schemas on Developmement and Productions, it will come up with every single packages/procedures due to the quotes on the Live Database. They are using TOAD to do the comparison.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|