Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » pool data in different schema's table (ora 10G apex 3.0)
pool data in different schema's table [message #309653] Fri, 28 March 2008 05:37 Go to next message
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 #309659 is a reply to message #309653] Fri, 28 March 2008 05:48 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Yes, login to yy and:
GRANT INSERT ON emp TO xx;

Login to xx and:
INSERT INTO yy.emp VALUES (...
Re: pool data in different schema's table [message #309662 is a reply to message #309653] Fri, 28 March 2008 05:49 Go to previous message
Mahesh Rajendran
Messages: 10707
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.
Previous Topic: Print server Configuration
Next Topic: datafile
Goto Forum:
  


Current Time: Thu Mar 28 12:54:00 CDT 2024