use of dbms_stats.import_table_stats package

[anandkl]

Hi friends,
I have exported the table statistics using the export_table_stats procedure of dbms_stats package.
Now i am trying to import back the statistics using the import_table_stats procedure,but i am getting the following error,can u please help me on this
exec dbms_stats.import_table_stats('andale','sfitem_archive','stattab');
BEGIN dbms_stats.import_table_stats('andale','sfitem_archive','stattab'); END;

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'IMPORT_TABLE_STATS'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

i tried all the remaning parameters of this procedure but did not succed.Can u please help me on this.

regards
anandkl

[Shestakov]

Parabmeters in dbms_stats.IMPORT_TABLE_STATS are:

PROCEDURE IMPORT_TABLE_STATS
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OWNNAME VARCHAR2 IN
TABNAME VARCHAR2 IN
PARTNAME VARCHAR2 IN DEFAULT
STATTAB VARCHAR2 IN
STATID VARCHAR2 IN DEFAULT
CASCADE BOOLEAN IN DEFAULT
STATOWN VARCHAR2 IN DEFAULT

U have to use:

dbms_stats.IMPORT_TABLE_STATS(
OWNNAME => 'andale',
TABNAME =>'sfitem_archive',
STATTAB =>'stattab',
);

because it has default PARTNAME between TABNAME and STATTAB.