Hi All,
I think it would be a good idea to see if any Views are dependent on
this/these table(s) as well, if the copydb is for one/some table(s).
Regards,
Andrew.
Denise Vancil wrote:
> As of Ingres 2.6, copydb -help shows you can copy out rules and
> procedures with extra parameters to copydb such as -with_proc
> -with_rules. I would think this is what you need to get your procedures
> and rules copied out.
>
> $ copydb -help
>
> E_UG0011 Correct syntax:
> copydb [-param_file=filename] | [ dbname [-c] [-row_labels]
> [-uusername]
> [-Ggroupid ] [-parallel] [-journal] [-P] [-source=dirname]
> [-dest=dirname] [-ddirname] [-with_tables] [-with_modify]
> [-with_data]
> [-all] [-order_ccm] [-with_index] [-with_constr] [-with_views]
> [-with_synonyms] [-with_events] [-with_proc] [-with_reg]
> [-with_rules]
> [-with_alarms] [-with_comments] [-with_roles] [-add_drop]
> [-infile=filename] [-outfile=filename] [-with_permits] [-relpath]
> [-no_loc] [-no_perm] [-noint] [-no_persist] [-no_repmod]
> {tablename|viewname}]
>
> - Denise
>
> Denise Vancil
>
> Senior Quality Assurance Engineer
>
> Ingres Cor****ation
>
> denise.vancil@[EMAIL PROTECTED]
> www.ingres.com
>
>
>
>
>
> -----Original Message-----
> From: info-ingres-bounces@[EMAIL PROTECTED]
> [mailto:info-ingres-bounces@[EMAIL PROTECTED]
On Behalf Of
> Norhaza Yusoff
> Sent: Thursday, May 08, 2008 11:19 AM
> To: Ingres and related product discussion forum
> Subject: [Info-Ingres] copydb with rules/procedures?
>
> Hello everyone,
> Is there a way to copy a table and get all the related rules and
> procedures be included in the copy.in script?
> We have been having a problem of forgetting to include the rules and
> procedures into the new table whenever we do the copydb to a table,
> which results in missing rules and procedures for that table.
>
> Anyone who has experienced with this issue or who knows the answer,
> please give us some insights.
>
> Thanks.
>
|
