Re: newbie questions

1 the latter. The only thing you really need is the tablespace SYSTEM, and a second rollback segment in that tablespace. 2 Yes, but the exact steps depends on whether you want to do relocation of files. If there's not any relocation, backup and restore the data and the software. Make sure you make a backup of the registry tree HKEY_LOCAL_MACHINE\software\oracle (and ALL it's subkeys) and import that to the registry of the new server.
If there is relocation you need to issue alter database backup controlfile to trace in svrmgr<xx> on the old system.
The trace file will go into the directory pointed by user_dump_dest. You will need to edit that file, changing filenames and follow the instructions in that file.
3 Export/import, the only other way is using a database link, and use the COPY sql*plus statement. Probably this is proving to be very cumbersome.

Hth,

--
Sybrand Bakker, Oracle DBA
<marcus_chan_at_my-deja.com> wrote in message news:7v448r$rib$1_at_nnrp1.deja.com...
> Hi,
>
> i'm new to oracle. I would like to know.
> 1. If i have a file (containing the "FULL" database export), do i need
> those tables ready (without any data) to accept the FULL import. Or,
> does the import generate those tables without tables being created at
> the first place.
>
> 2. Is it possible to restore database at the new NT server. Both backup
> and restoring will be on the same platform (NT) but different PC. If
> yes, what should I do?
>
> 3. How to move a database (fastest way) from one platform to other
> platform, eg. NT to AIX?
>
> Thanks
> marcus
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Oct 26 1999 - 08:21:29 CDT