Re: Importing Data

From: Marcus.Wilkinson@ssa.co.uk > >I am new to the Informix arena and running Informix On-Line 7.3 UC5. I >have a couple of questions. > >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 you >create all the indexes which makes a significant improvement during import. >Is this possible with Informix. This is the default (only?) behaviour of the dbimport program. You can certainly do this in your own scripts. >2. Looking through the faq's I see that there is a utilities called >tbcheck -ce ( reports on tables having more than 8 extents ) > tbcheck -pT <dbname>:<owner>.<tabname> to get Tablespace usage >(Version 4.10.UE1). Is there an equivalent for 7.3 UC5?? Yes. oncheck does what tbcheck used to do. HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com