In article <366d6203.1533690199_at_news.goodnet.com>, Scott Dudley
<scott_at_telesoft.com> writes
>
>
>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.
What you will need to do is extract some info out of your original
database first so that you can create an 'identical' copy.
Look at dba_tablespaces which will tell you about the various
tablespaces and their default storage clause, dba_logfiles will hold
details of the redo log files, dba_controlfiles has details of the
control files
Alternatively you can log onto the orginal database with sqlplus or
servermanager (svrmgrl on Unix) and issue the command alter database
backup control file to trace. This will create a trace file which
contains details about the tablespaces and you can use vi to have a lokk
at that.
have fun
--
Diane
Received on Tue Dec 08 1998 - 14:03:31 CST
