Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Question for DBA ?

Question for DBA ?

From: Scott Dudley <scott_at_telesoft.com>
Date: Tue, 08 Dec 1998 17:29:50 GMT
Message-ID: <366d6203.1533690199@news.goodnet.com>

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 - 11:29:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US