Question for DBA?
I'm a new Oracle devloper/user. I've been developing for Oracle 8 on
NT and have recently installed O8 on my Linux box at home. The
default Linux install creates only a system tablespace by default.
When I try to import a database from my NT box, it moans about two
tablesspaces not existing and pukes. I then created the other two
tablespaces, temporary and user, created my user, and then the import
works. I quite frankly "hacked" my way through this process as I'm
completey ignorant of Oracle DBA tasks. I have years' experience with
Informix and am having a tough time making the transition. In light
of the aforementioned, is there a way to create a script, etc. from
one installation and run it on another, as in this case, and have it
create the tablespaces, users, etc so that an import will succede?
Any and all suggestions appreciated (short of RTFM for which I have
no free time at present).
Many thanks.
Received on Tue Dec 08 1998 - 18:29:13 CET
Original text of this message
