Re: Help: Copy tables and indexes to another user

Mark D Stock wrote: > > I presume you are copying a table to the same database. I'm not that clued > up on ANSI databases, they privide too many cons and no pros. However, I > think you are going to have to re-name the indexes on the copy, because > index names are unique across the entire database. > > Cheers, > -- > > Mark. > > +-------------------------------------------------------------------------+ > |Mark D. Stock - The West Solutions Group http://www.west.co.za | > | | > |mailto:marks@west.co.za +------------------------------------------------+ > |Tel: +27 11 803 2151 |If it doesn't work... force it! | > |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | > |Cell: +27 83 250 2325 |Well, that's how I code anyway! | > +------------------------+------------------------------------------------+ Hi Mark ! The Informix manuals say, that in an ANSI-compliant database owner.name is case-sensitive for indexes, too. In addition, I have the problem, that I can't change the names. They have to be the same for the new user. And you are right, that I try to copy to the same database. I know, that it's not a very elegant way to handle multiple users. But that's the way it is! Thanks for your comment, so far ! Dirk --------------------------------------------------- Dirk Schmidtpott S I E M E N S EMail: schmd@dbm212.pdb.sni.de ============= Phone: 0049-5251-8-14922 N I X D O R F Fax : 0049-5251-8-27905 The above statements and opinions are my own and do not necessarily represent those of my employer. ---------------------------------------------------