Re: Novell to Win2k

From: Mark Bole <makbo_at_pacbell.net>
Date: Wed, 12 May 2004 02:46:59 GMT
Message-ID: <Degoc.66309$HH2.37599@newssvr25.news.prodigy.com>

Frank van Bortel wrote:

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

There's also the SQL*Plus "copy" command, which is an alternative (predecessor?) to a database link for copying table data. Forgot about that one... it's still documented in an appendix for Oracle 9i at

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a90842/apb.htm#634246

it's a version-appropriate tool for Oracle 7 (but will go away some day).

--Mark Bole Received on Tue May 11 2004 - 21:46:59 CDT