Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Novell to Win2k
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. >>
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
![]() |
![]() |