Ask the Expert

Unknown error on daily backup using Oracle export

We have exported a database from Microsoft Access 2000 to Oracle 8i version 8.1.7 using self developed export utilities. For daily backups I use Oracle export. I got the following error to one table FPTEMPLATE while exporting the database using Oracle export. That is the only table that contains a column having datatype varchar2 size 4000. The table description shows the datatype correctly varchar2(4000). The error during export of table FPTEMPLATE is "EXP-00018: datatype (0) for column TEMPLATE, table TNTUSER.FPTEMPLATE is not supported."

Please tell me why the error is occuring and what I should do to backup the database including the table.


    Requires Free Membership to View

This error can occur when you use an older export version to export the database. For instance, if you are using Oracle's 8.0 or 7.3 export to export an Oracle 8i database, then you can get this error.

If you are running the 8i export and still hitting this problem, then it is possible that there is some problem with the data dictionary. Sign on to the database as SYS and run the ORACLE_HOME/rdbms/admin/catexp script and try to do the export again.


This was first published in September 2004

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: