I want to update an Oracle database. I have a script that generates other scripts to export data but some of the strings are more than 2000 characters and export doesn't accept this. I can't reduce the length of the string. I would like to know a method to do the export.

    Requires Free Membership to View

If you are hitting the limit because you are listing all the table names, you can put each table name on it's own line. Try something like this ....

exp system/manager file=full.dmp tables='table1
,table2
,table3
...

table999'

This was first published in February 2002

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.