Re: Database restore

I haven't tried this but it should work. Do a dbexport to disk of the database you want to move. This creates a directory called <dbname>.exp. Rename the directory to <new dbname>.exp. Run dbimport <new dbname> from the parent directory of this .exp directory. If it doesn't, contact me my email and I have a korn shell script that walks thru all tables in a specified database and writes them out to disk. You can tweak it to actually write to the new database. Arun John Harman <harmanj@agric.nsw.gov.au> wrote in article <6iotat$9s$1@news.xmission.com>... > > > I'm a 'thrown to the wolves' DBA owing to the sudden illness of a > co-worker. Need some fundamental type advice. I need to copy a database > from one machine to another, but I want to restore it as a different name. > > i.e. The source database is called 'aurprod'. I want create this > database on another machine, call it 'aurtest', and load the data from > 'aurprod'. Should be routine ?? There just doesn't seem to be a [source > database name] [destination database name] type option. > > John > > >