| create table from database link [message #63953] |
Mon, 29 November 2004 23:26  |
newzys
Messages: 1
Registered: November 2004
|
Junior Member |
|
|
when I run follow sql:
create table device_tmp as select * from device@remoteoradb;
if table device_tmp's column type is varchar2 or char etc,the size of the local table column size is mul 2, as varchar2(10)--[>]varchar2(20);
local oradb and remote db characterset is diff.
what can i do?
|
|
|
|
| Re: create table from database link [message #63955 is a reply to message #63953] |
Tue, 30 November 2004 00:06  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>>local table column size is mul 2
what is a mul 2 here?
Never use your owne Abbreviations.
anyhow when you issue
sql> create table device_tmp as select * from device@remoteoradb;
a local table called device_tmp is created JUST like the device table in remotetb (without constraints).
It will not have difference in columns.
If You already have a table with different domains
( like varchar(10) and varchar2(20)) then
use an insert statement.
sql> insert into device_temp ( select * from device@remoteoradb);
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
