Discussion Locked

How to copy data of oracle

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Dear Friends,
How will u store oracle data on some other devices such as floppy or tape or zip drive?

5 replies

by satheesh

Hi,
Use export command to export
1. User
2. Table
3. Table Space
All these options could be performed ans stored in a .DMP File,which could be stored in any media(Floppy,CD,ZIP Drive,Tape,etc)

The Exported data can be imported in the same way using the Import Command

With Regards
S.Satheesh

by sridharpandu

Just a word of caution though while using Oracle Export / Import. The import will work only if the versions of Oracle match i.e. the database to which you import data should be the same version as the database from which you exported the data.

This discussion is closed to new replies.