On Sat, 15 Jul 2006 10:26:55 +0530 "VivekanandaSwamy R." <VivekanandaSwamyr@xxxxxxxxxx> wrote: > > > Hai all, > I have 2 databases namee PAO and CAS. > PAO contains 3 schemas named Public,pao,sts > CAS contains 4 schemas named Public,cao,sts,reports > > Now i am in PAO database..now i want access table 'activity' in > schema 'cas' in CAS database. > How it is posible. > > 2nd thing is... > > i have 2 servers access i.e local and mainserver. > > How access table from one server to another server? > > please tel me...because we need this one Vivekananda, I hope you just want the first one. I think what you need is to re-think your database design.