Re: Importing Data

>>> <Marcus.Wilkinson@ssa.co.uk> 06/07/99 05:52pm >>> Hi, 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. 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?? Thanks for your help. Marcus Wilkinson ________________________________ The information contained in this electronic mail message is confidential. It is intended solely for the use of the individual or entity to whom it = is addressed and others authorised to receive it. If the reader of this message is not the intended recipient, you are hereby notified that any use, copying, dissemination or disclosure of this information is strictly prohibited. ________________________________ ********************************************************************** 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 **********************************************************************