Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: moving database in the filesystem

Re: moving database in the filesystem

From: George Dau <gedau_at_isa.mim.com.au>
Date: 1998/01/18
Message-ID: <34c18dc4.8979611@isafin1>#1/1

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.com
Received on Sun Jan 18 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US