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

:>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 ... You can specify a -d <dbspace> as a dbimport parameter. It is also a valid parameter for tbload. David W Chan Objective Research Ltd dwc@cix.compulink.co.uk