[born_a_diablo]

Hola all
im a beginner in oracle.
i wanna know how to save my database from my pc n to run it in any other pc. is that possible.................................... i have created table and wrote the script file,,, now im to run present that in class........ and i still dont know how to save the whole database... it compress' of only three short table.

thanx in advance
matezz

[gbrabham]

1st... You have to have Oracle installed on the other pc...

The best way to make a copy of an Oracle Database is by using the
export/import utility...

If you have the same directory structures on both PC's then a full
export/import is the best ... Ensure that the directories where Oracle
resides now, exists on the new machine BEFORE doing the import ...

ie:
old machine: c:\oracle\oradata\data

new machine: the above directory MUST exists to let the import build
the entire database.

You should create you an instance on the new pc first.
export the data second with full=Y
import the data third

[born_a_diablo]

K thanx is this the correct way of exporting the database? ,lets say after I have created a table
exp a:/"filename"??

Originally posted by gbrabham
1st... You have to have Oracle installed on the other pc...

The best way to make a copy of an Oracle Database is by using the
export/import utility...

If you have the same directory structures on both PC's then a full
export/import is the best ... Ensure that the directories where Oracle
resides now, exists on the new machine BEFORE doing the import ...

ie:
old machine: c:\oracle\oradata\data

new machine: the above directory MUST exists to let the import build
the entire database.

You should create you an instance on the new pc first.
export the data second with full=Y
import the data third

[gbrabham]

To export only a table ...

exp username/password@service tables=(tablename) file=c:\...\a.exp


Gregg