Home » RDBMS Server » Backup & Recovery » export oracle database...
export oracle database... [message #160098] Thu, 23 February 2006 04:04 Go to next message
tayyaba
Messages: 4
Registered: February 2006
Location: Pakistan
Junior Member
plz can some body help me that how can I move my Oracle database from my systems hard disk to an external hard disk...and then again load it in another system...plz it's really urgent...reply me as soon as possible...

Report message to a moderator

Re: export oracle database... [message #160192 is a reply to message #160098] Thu, 23 February 2006 15:58 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
I moved your thread to a different forum. Please search this forum for 'move database' and see what comes up. I expect that the people who 'inhabit' this forum will be able to help you further.

David

Report message to a moderator

Re: export oracle database... [message #160447 is a reply to message #160192] Sun, 26 February 2006 04:03 Go to previous messageGo to next message
tayyaba
Messages: 4
Registered: February 2006
Location: Pakistan
Junior Member
there is still no reply to my problem...plz I need help...it's really urgent..

Report message to a moderator

Re: export oracle database... [message #160448 is a reply to message #160447] Sun, 26 February 2006 04:21 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Depends on how complex things are and volume of database.
If the source and target are of same OS/Oracle version, then you may be able to just copy files and mount the instance in other system (search the board for COLD COPY).
or
You can export from the source and import into target.
http://www.orafaq.com/faq/import_export

[Updated on: Sun, 26 February 2006 04:22]

Report message to a moderator

Re: export oracle database... [message #160540 is a reply to message #160448] Mon, 27 February 2006 03:32 Go to previous messageGo to next message
tayyaba
Messages: 4
Registered: February 2006
Location: Pakistan
Junior Member
Hi..
Thanks for your help...
well my database is in Oracle 9i and I'm working on windows 2000...it contains about 30 table with no much data...

are u talking about message #68974...by the name of Cold Backup...do I have to do the same process?? and what are archive files...

actually I have to give my database to another person so that he can link som ASP forms to it...and I'll give him the database in an external hardisc(like Flash Memory) which is 40 GB...so, what and how should I do this???
plzzzzz reply me as soon as possible...I only have two to three days...I shall be very gratefull to u for ur help...

bye

Report message to a moderator

Re: export oracle database... [message #160585 is a reply to message #160540] Mon, 27 February 2006 07:19 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Export/import will do for you.
Look into the link in previous posting.
For more information, look into utilities manual.

Report message to a moderator

Previous Topic: Restore Oracle 9i DBF files into Windows XP server
Next Topic: Problems with Netbackup and oracle 8i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 21:20:35 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.