Uploaded image for project: 'JBoss Enterprise SOA Platform'
  1. JBoss Enterprise SOA Platform
  2. SOA-3033

Issue during importing of Oracle metadata when the schema is partitioned

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: None
    • Fix Version/s: 5.1.0 GA
    • Component/s: EDS, Tooling
    • Labels:
      None

      Description

      The Table is BIG ! - The Oracle table that we're importing is partitioned by date with 5 million rows per day and 2 years worth of data.
      The problem is that it takes longer than 2 hours because it issues an ANALYSE table command.
      Would it be possible to create an option (perhaps a checkbox) that would allow the meta data to be created quiclky and defer the ANALYSE to runtime?

      create an option (perhaps a checkbox) on Import from JDBC that would allow the metadata to be created quickly and defer the ANALYSE to runtime. Also, it was indicated that the ANALYSE call is an old Oracle command, that there is a newer command. Also, consider running the stats only only the requested partition.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  van.halbert Van Halbert
                  Reporter:
                  dsteigne Deborah Steigner
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: