Forum Stats

  • 3,876,212 Users
  • 2,267,082 Discussions
  • 7,912,473 Comments

Discussions

TABLE schema_name.* :: Schema Replication

837734
837734 Member Posts: 49
edited Mar 1, 2011 11:57PM in GoldenGate
Hi ,

What is the EXTRACT command parameter for extracting changes from all the tables in a schema ( assuming there are around 4000 tables in the schema that is being replicated ).

Is it that we can use TABLE schema_name.* ?

e.g TABLE SCOTT.*

Thanks
Hiren Pandya

Best Answer

  • stevencallan
    stevencallan Member Posts: 3,459
    Answer ✓
    Page 35 Admin Guide

    Using wildcards
    For parameters that accept object names, you can use an asterisk (*) wildcard to match any
    number of characters. Owner names, if used, cannot be specified with wildcards. The use
    of wildcards reduces the work of specifying numerous object names or all objects within a
    given schema.

Answers

This discussion has been closed.