Ask the Expert

Exporting data limit

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

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: