Re: DBEXPORT/DBIMPORT to move tables to another DBSPACE?

Posted in 1995

L Deckard — Thu, 9 Feb 1995 16:36:30 LOCAL — source: Informix-list mailing list archive (1991-1998)

The sql that is created by the DBEXPORT has no 'create database ...' in it. ?? Lenny... In article <D3q7Ht.C1E@demon.co.uk> andyw@mountfield.co.uk (Andy Wilson) writes:>From: andyw@mountfield.co.uk (Andy Wilson) >Subject: Re: DBEXPORT/DBIMPORT to move tables to another DBSPACE? >Date: Thu, 9 Feb 1995 09:25:01 GMT >In article <ldeckard.33.0009067F@databank.com>, ldeckard@databank.com says... >> >>I have a 100 tables defined in a database in ROOTDBS. I would like to DBEXPORT >>the database and DBIMPORT all the tables back into the same database name, but >>in *another* DBSPACE name. What is required to do this? Is there a parameter in >>the DBIMPORT command or do I need to edit and change the *.sql file that is >>created by the DBEXPORT command?? Thanks! Lenny. >You guessed right, edit the sql file and change the create database statement to "create >database in dbspace ..." >You'll need to check the exact syntax 'cos I haven't got a manual handy, and I've got >the memory of one of those little slimy aquatic things ... >-- >+==============+=======================+======================+==========+ >| Andy Wilson | Mountfield Software | St Leonards-On-Sea | England | >+--------------+-----------------------+----------------------+----------+ >| andyw@mountfield.co.uk | Compuserve 73171,3627 | >+======================================+=================================+