OraFAQ Forum: Server Utilities » Importing Schemas From One Database to Other Database

Home » RDBMS Server » Server Utilities » Importing Schemas From One Database to Other Database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Importing Schemas From One Database to Other Database [message #271478]

Mon, 01 October 2007 13:42

vpaleti
Messages: 2
Registered: March 2007

Junior Member

Hi this is the ISSUE i have

a database with 4 schema's on one server.....it is a development database on server ASD

Now i have to create a test datbase on Other Server with the 4 shemas .(it is a consiladated database.......and i have to just keep the 4 schemas from the old server to this one)

1)i have taken all the exports of the 4 schemas in the first server
2)i did FTP and copied all the schemas on to the other server.

the version of oracle is 10.2.0.2

3)MY question is if i will import all the schemas on to the new database.....willl they be working fine????

please help me...

[Updated on: Mon, 01 October 2007 16:15]

Report message to a moderator

Re: Can Anyone please HELP me!!! [message #271484 is a reply to message #271478]

Mon, 01 October 2007 13:50

Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Before posting you have to read and follow OraFAQ Forum Guide, especially section about silly and meaningless title.
Always post your Oracle version (4 decimals).

Regards
Michel

Report message to a moderator