Results 1 to 2 of 2

Thread: analtable.sql

  1. #1
    Join Date
    Jul 2003
    Location
    US
    Posts
    314

    Arrow Unanswered: analtable.sql

    Hi
    I exported a table by the name of table1, and imported the same on a different server.
    Among all the files(SQL files) generated, there was another file, table1.analtable.sql which I presume is for analyzing the data. I wanted to know where does the analyzed data get written to.

    I am not sure as to what Table Analyzed involve or perform, so I would appreciate insight into this aspect.

    Thanx and Regards
    Aruneesh

  2. #2
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    I don't think you did run an "export" not in the Oracle sense of the word, you may have used a third party tool to export scripts etc, but not an Oracle export (Oracle export does not generate SQL files).

    TOAD <> ORACLE <> TOAD.

    Statistics (gathered by the analyze table command or by pre-supplied packages) are stored in a number of system tables (views).....

    user_tables
    user_indexes
    user_histograms

    and by definition the "all_" variants thereof.

    Hth
    Bill

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •