Re: how do I transfer tables between Oracle databases?
Date: Sat, 21 Jul 2001 21:47:32 GMT
Message-ID: <9f5l9k$423$1_at_news.tpi.pl>
Use export/import tools. You can export all user from database and import them to other database.
You can even duplicate /ORANT/DATABASE directory, but you need to be more
expierenced.
Just shutdown database, copy /<ORACLE_HOME>/DATABASE directory, install
other database on diffrent machine
shutdown it, and replace /DATABASE with old one. ( Should work if both
installed on same drive ( C: ) )
U¿ytkownik "NW" <narw_at_hotmail.com> napisa³ w wiadomo¶ci
news:thclh0989eo82c_at_corp.supernews.com...
> Hi,
>
> I am very new to Oracle database. What is the easiest way to transfer
> both schema and data from one Oracle to another Orcale database? We are
> running Oracle 8i under Windows NT 4. Thank in advance.
>
>
>
>
Received on Sat Jul 21 2001 - 23:47:32 CEST