Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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 BortelReceived on Tue May 11 2004 - 13:59:35 CDT
![]() |
![]() |