Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: moving database in the filesystem
Steven Egberghs <steven.egberghs_at_advalvas.be> wrote:
]F50
]AIX 4.2.1
]Oracle7.3
]
]I have a database in /database/prod
]and I want to move that database to eg. /database/prod_line_1
alter database rename datafile ......
]Together with that I need to change the SID.
Can be done, but after reading the process required, I exported the database, created a new one with the new SID and imported the database.
]
]What are my possibilities.
]
]Regards Steven.
-- ,-,_|\ George Dau, __ / * \ Unix (Solaris, DEC Unix, Linux), NT, Oracle, Internet. (OO) \_,--\_/ Home: gedau_at_pobox.com Work: gedau_at_isa.mim.com.au ( \/ ) v WWW: http://pobox.com/~gedau W--W Food for spambots: kunta_at_cheerful.com scout_at_pluto.skyweb.net millennianet_at_earthlink.net orion_at_opportunitygroup.com mailbox_at_irantel.com server_at_san.rr.com mwa234_at_hotmail.com stanleyo_at_hotmail.com GrtBiz4u_at_hotmail.com stanleyo_at_hotmail.com jobs_at_netpromo.net westcomm_at_teleport.com richl_at_stockscape.com response_at_starnetc.com OKremove_at_hotmail.com mutuu63_at_mpx.com.au starter_at_mail.net geolog_at_mail.net telecard_at_bigfoot.com kristen_m19_at_hotmail.com SecretsUnleashed_at_juno.com relatedmi_at_prodigy.net ubl_at_euro-land.comReceived on Sun Jan 18 1998 - 00:00:00 CST
![]() |
![]() |