| pool data in different schema's table [message #309653] |
Fri, 28 March 2008 05:37  |
dr.s.raghunathan
Messages: 540
Registered: February 2008
|
Senior Member |
|
|
there is one tablespace name xx
scheme xx
and password xx
Within this there is a table emp populated with data.
Another tablespace name yy
scheme yy
and password yy
In this tablespace also emp table is available with
same structure of xx schema.
I logged in using xx tablespace.
can I insert data into yy tablespace, yy schema using
xx tablespace xx schema emp data.
I want to do through sql command...
can any one throw some lights on this topic
yours
dr.s.raghunathan
|
|
|
|
|
|
| Re: pool data in different schema's table [message #309662 is a reply to message #309653] |
Fri, 28 March 2008 05:49  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
EMP is table in SCOTT populated with values.
ANOTHER_SCOTT.EMP is the other emp.
SCOTT (current Schema) has rights to insert into ANOTHER_SCOTT, this will work.
scott@9i > insert into another_scott.emp (select * from emp);
14 rows created.
And
>>I logged in using xx tablespace.
Wrong term.
You login to a schema or as a user.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
