How can we improve our Oracle tools?

Specify tables to compare up front

We frequently bring data from production databases to staging and development environments, it involves around 120 tables , but to start with we want to pick 3 or 4 huge tables(rows ~ 3 million) and see how much time it will take to do data comparison and deploy differences, instead of copying down entire tables.Also please see if you can develop the functionality of selecting a list of tables for comparison before registering entire databases.

16 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    3 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Cliff Clapham-SteeleCliff Clapham-Steele commented  ·   ·  Flag as inappropriate

        I believe this feature to be an important one for those users where the number of tables i the schema is significant e.g. applications such as PeopleSoft, e-Business etc.

        How this filtering/selection is actually specified by the user is very important given that the schemas we are talking about may contain 60,000+ tables.

        In my view the most flexible approach to this would be to allow a user specified WHERE clause. I would certainly like the ability to include/exclude tables based on a variety of criteria e.g.

        1. Table name prefix/suffix or substring (REGEXP match)
        2. Tablespace i.e. I would like to include/exclude all tables in a given set of tablespace(s)

        And many others .... :-)

      Feedback and Knowledge Base