Re: DBEXPORT/DBIMPORT to move tables to another DBSPACE?
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.
Just use flag -d <dbspace> with the dbimport command and the DB will be
created in the desired dbspace.
Easy isn't it?
CU,
Stefan
>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 |
>+======================================+=================================+