Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Stupid Newbie Question
If you're totally new, the Oracle docs can be hard to follow, try and lay
your hands on Oracle 8 the complete reference, it's well worth the money, it
also explains database theory in relation to Oracle, HTH
--
Colm Hoban
Oracle Certified DBA
http://www.dbmonitor.com
Sybrand Bakker wrote in message
<930390229.12752.0.pluto.d4ee154e_at_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 - 17:10:14 CDT