Tips and Tricks

General discussion


Copying Database schema

By shaikahmadbasha ·
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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by Jaqui In reply to Copying Database schema

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.

Collapse -

by shaikahmadbasha In reply to

Poster rated this answer.

Collapse -

by asifnaveed11832 In reply to Copying Database schema

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.

Collapse -

by asifnaveed11832 In reply to Copying Database schema

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

Related Discussions

Related Forums