Re: Importing Data

>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. Not by default, you can edit the db creation sql file so the indexes = aren't included then run a normal dbimport. >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?? Generally change tb to on for the 7.x equivalents of the 4.x commands Paul Watson WF Software Ltd Tel +44 1436 674729 Fax +44 1436 678729 www.wfsoftware.co.uk ********************************************************************** 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 **********************************************************************