Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Developer & Programmer » Application Express & 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: 111
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
Report message to a moderator
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: 3657
Registered: January 2002
Senior Member
Yes, login to yy and:
GRANT INSERT ON emp TO xx;

Login to xx and:
INSERT INTO yy.emp VALUES (...
Report message to a moderator
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: 8469
Registered: March 2002
Location: Live Free or Die
Senior Member
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.
Report message to a moderator
Previous Topic:Print server Configuration
Next Topic:datafile
Goto Forum:
  

[ Syndicate this forum (XML) ] [ ]

Current Time: Sat May 17 03:51:15 CDT 2008

Total time taken to generate the page: 0.04014 seconds
.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.