Re: Novell to Win2k

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