Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to export/import thesaurus from one DB to another ?

28499Jul 12 2002

Hi !

I want to export a user's thesaurus from one database (Personal Oracle 8.1.7 on WinNT 4.0) to another (Oracle 8.1.7 on W2K) using. But I'm not able to dump the user's thesaurus to a file. I'm using the following command:

ctxload -user USR/PWD -name DEFAULT -file THES.TXT -thesdump

But I get error: ORA-01403: No Data found

The user is granted CTXAPP. The thesaurus was created using CTX_THES.create_thesaurus('Default'). The thesaurus is working correctly.

TIA,
Stefan.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 29 2002

Added on Jul 12 2002

#database-key-features, #text

6 comments

409 views