Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

dbexport - dbimport 1

Status
Not open for further replies.

confuzd

Technical User
May 14, 2002
5
GB
People. Any help appreciated. My dbexport works fine. However the dbimport fails to complete. The reason is that the sql file has a "create view" in it that is dependant on a table that dosn't get created until later on in the sql file! O.K. so I re-arrange the sql file and the import works. My question is basically 1) why does the export behave in this way? and 2) can I do something to modify it's behavior? I suppose i wondering how dbexport works in the first place. (informix 7.23) Thanks.
 
dbexport -ss ..... usually works fine

although servers prior to 7.30 have different mysterious bugs - so it is up to you to get it working "correctly"
 
Use dbexport with server specific syntax

dmexport -ss -d < database>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top