I have one partitioned table with partitioned index. Exported data was ok without any error. But when I imported data using the following command and got error message "IMP-00058: ORACLE error 904 encountered".
imp myschema/password@xxx buffer=16384 ignore=y indexes=n grants=n file=myexp.dmp log=imp.log commit=y feedback=1000000 full=n tables= tablename
I created one new table which would get the imported data. The new table has one difference. It was changed from PARTITION BY RANGE(another_column) to PARTITION BY HASH(one_column)
Any options need to be set up when importing data from the partitioned table (partitioned by range) to the partitioned table (partitioned by hash)?