Tips and Tricks
How can we copy database table along with eniter schema from oracle to a non removale disk such that we can directly use it in another system (not in a network)by simply copying table in to
oracle database of that system?
by jaqui
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.
Poster rated this answer.
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"""
This discussion is closed to new replies.
Sort by Trending