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

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