Re: dbexport did not create indexes
Posted in 2003
How do you spell "next"? Hopefully not "nect" as in your log...
Darren Robertson wrote:
>>When trying to import a database it was discovered that the export had
>>not properly created the indexes. Any ifeas>#
>
>
> First of all thanks for the feedback I have received for this already.
>
> Further.
>
> I've been able to get the dbexport.out file and it doesn't complete.
> Hence why no indexes are created. Looking at this made me think as if
> the problem lies with the size/number of extents. However searching
> through this NG has shown that the "error" is quite generic and will
> show up in a number of different situations.
>
> create table "user".protocol
> (
> dbprotocol integer not null
> ) extent size 16 nect size 16 lock mode page;
> revoke all on "user".protocol from "public";>
> This is the last entry of the dbexport. Any further feedback would be
> greatly appreciated.
>
> Thanks.
>
> D.
>
--
( ______
)) .-- Scott MacKenzie; Dine' College ISD --. >===<--.
C|~~| (>--- Phone/Voice Mail: 928-724-6639 ---<) | ; o |-'
| | \\--- Senior DBA/CARS Coordinator/Etc. --/ | _ |
`--' `-- E: scottm at dinecollege dot edu -' `-----'
sending to informix-list