Re: Question for DBA?

Scott Dudley wrote:

> 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.

Scott,

You would have to worry about the UNIX "/" vers the DOS "\" while specifying your data files. A sql script could be used to create a tablespace or a user.

Cheers,

Tendo Received on Wed Dec 16 1998 - 12:15:37 CET