Re: Importing Data

My misundestanding, I thought the original question was how to use = dbimport and end up with a database without any indexes. Paul Watson WF Software Ltd Tel +44 1436 674729 Fax +44 1436 678729 www.wfsoftware.co.uk >>> Obnoxio The Clown <obnoxio@hotmail.com> 06/08/99 09:15am >>> From: "Paul watson" <watsop@russellcorp.co.uk> > > >1. Is it possible to import a schema's data only and then running a = sql > >script after to create the indexes. In Oracle you specify not to = create > >the indexes and then run a sql script that the imp utility creates = for=20 >you > >create all the indexes which makes a significant improvement during=20 >import. > >Is this possible with Informix. > >Not by default, you can edit the db creation sql file so the indexes = aren't=20 >included then run a normal dbimport. Yes, but since dbimport only creates indexes after the data is loaded for = a=20 specific table anyway, what's the difference? :-) ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **********************************************************************