This discussion is archived
8 Replies Latest reply: Sep 5, 2013 12:56 AM by Anthony Dodds RSS

Import issue

904244 Newbie
Currently Being Moderated

Hi Gurus,

Here is my requirement.I am exporting(full export of level0) file then defrag db ,again building the dimensions then refresh fnally  want to load exported(level0) file back.for that i used the following script.

To Export:

SET DATAEXPORTOPTIONS
  {
DataExportLevel "LEVEL0";
DataExportDecimal  6;
DataExportOverwriteFile ON;
DataExportRelationalFile ON;
};
DATAEXPORT "File"  ","  "E:\HYPERION\logs\export.err";


I am getting exported file.and i would like to import again.that time i am getting warning given below.

import database 'APPNAME'.'DBNAME' data from local text data_file 'E:\HYPERION\DATA\export.txt' using server rules_file 'loadplan' on error write to 'E:\HYPERION\logs\export.err';

statement executed with warnings
No data values modified by load of this data file
there were errores in E:\HYPERION\logs\export.err


can you pls suggest.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points