DIET Fatal error message: Can not export on Clarify version 12 or above on Oracle (Article # 304)
View products that this article applies to.
Problem:
Performing an export with DIET in Oracle on Clarify 12 or above yields an error:
DIET version 2.1.12(d) for Oracle 9i for NT
Copyright 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006. First Choice Software, Inc.
Compiled Apr 25 2007 13:47:00
Run Time Thu Jun 05 17:10:03 2008
NOTICE - logging into database, pulling basic object information
FATAL - Can not export on Clarify version 12 or above on Oracle
Compilation Unsuccessful :
1 Notices Encountered
1 Fatal Errors Encountered
DIET version 2.1.12(d) for Oracle 9i for NT
...
Resolution:
The problem is that -export is a crude and ill advised form of exporting
data from the database. There is no functionality with -export that
can not be done with -archive or -purge. In Clarify 11+ the Oracle
database versions of Clarify started using the clob datatype. This
resulted in a lot of coding changed in DIET. It was decided not to
take the time to make the changes into -export. Clobs are completely
supported in -archive and -purge.
Instead of using -export, use -archive
Applies To:
-
ArchiveManager – Dovetail ArchiveManager (formerly Data Import Export Tool)