Tips and Tricks

db dump, with full inserts.

add create statements options also.
then you have an sql query with the structure and contents of the db, transfer that to the other machine and run the sql query on the new server.
( easier if both were connected, then do database replication between servers.

You can do this by export/import command.
Go Start menue and command Run "write exp" and in dos mode write system and its passward. press enter twice write file name in front of EXPDAT.DMP> like d:\abc.dmp a message appear 1(entire databas) 2(users) 3 (table)chose 1, 2 or 3 export grant y press enter, export table data y press enter,Compress extents y press enter write table or user name press enter
then message appear user to be exported you can see this dump file abc.dmp on drive which you selected. and in import command do the same first message press n other all message press y do it hope fully you entire schema will copy on removale disk.

Syntax for 'EXP' command with a query form the command line:
Exp scott/tiger=h:\emp.dmp tables=dept,sal query ="""where empno = 7659"""