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 -> Re: Novell to Win2k

Re: Novell to Win2k

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Tue, 11 May 2004 20:59:35 +0200
Message-ID: <c7r7jr$f4g$1@news5.tilbu1.nb.home.nl>


Bill Van Dyk wrote:
> Okay, sounds good. How do I do this? Another posts suggests:
>
>
> create table t_name as select * from schema.t_name_at_dblink;
>
>
> From where? From SVRMGRL on the Win2k Server? Or using an export utility?
>
> In the example above, I believe our schema name is "contact", which is
> also the owner of the tables. Is "t_name" the name of one table?
>
> Thanks.
>

Could be svrmgrl, but I'd use sql*plus, and log on as the (new) user on the Win2K system.
t_name is indeed the name of the table, so you would have to repeat for all tables.

First you would have to setup a database link, meaning configuring the Win_at_K side of oracle to recognize your Novell 7 instance.
Once you get it there, I would use export/import; for the simple reason it will bring over all objects (views, sequences, triggers, contraints, etc) which 'create table' does not.

-- 

Regards,
Frank van Bortel
Received on Tue May 11 2004 - 13:59:35 CDT

Original text of this message

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