Re: Stupid Newbie Question

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 26 Jun 1999 11:44:49 +0200
Message-ID: <930390229.12752.0.pluto.d4ee154e@news.demon.nl>

Hi Thomas,

Tables are stored in tablespaces, which are stored in physical datafiles. select * from dba_data_files connected as sys or system (or internal in svrmgrl)
You can move databases
You can not 'merge' two databases by just moving a datafile In that case you need to export and import the data Please try to get and read the Oracle Concepts Manual. It should be available on technet.oracle.com

Hth,

Sybrand Bakker, Oracle DBA

Thomas Fischer wrote in message <37747f32.345467395_at_news.deakin.edu.au>...
>hi,
>
>i installed Oracle 8 on my Linux box and started playing around
>with it on my humble newbie level. I created some tables
>and here is my question:
>
>Where the hack does Oracle store the tables?
>Is there something like a file which can be transported
>to another machine running Oracle?
>
>Thomas
Received on Sat Jun 26 1999 - 04:44:49 CDT