Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to import the database from another server?

Status
Not open for further replies.

GoSooJJ

Programmer
Feb 24, 2001
76
US
Hi,

I used INCTYPE export to Complete, Incremental, and Cumulative from Oracle server1.
Then I tried to import this full export backup to Oracle server2 but I'm getting bunch of errors. First, it said filepath is not found, I created alias to point as original data path. Then next import run gives they can't create tablespace, I tried to run many times with different ways then it created users.

My question is if I do Full Database Mode export, I can't restore to different oracle server? If I can, what's requirement for this? I really need to use INCTYPE(just backup changes daily type) to backup database and able to replicate to different server.

Thx all.
 
Thank you for reply sem.

I have other question if you or anyone can answer.
Can I export just few Owner with INCTYPE? It seems like it conflict with OWNER and INCTYPE same time. If this doesn't work, can anyone recommend other backup type that do very similar to INCTYPE?

Thx all~
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top