Re: How can i copy data from one table in one tablespace to table in a difft tablespace?

Hi there,
Thanks. this worked
'insert into <table at tablespace users> select * from <table at tablespace
> test>'.

17 / 18 were our application schema internal version numbers

-avsrk

"Guido Konsolke" <Guido.Konsolke_at_triaton.com> wrote in message news:<1048147772.282673_at_news.thyssen.com>...
> "Subrahmanyam Arya" wrote...
> > Hi All,
> >
> > I want to restate my previous question in a slighlty different way.
> > How can i copy data from one table in one tablespace to table in a
> > difft tablespace? In my application until schema version 17 a table
> > was in 'users' tablespace and from version 18, it was moved to a difft
> > tablespace 'test'
> >
> > Is there anyway to copy the data from version 17 on users tablespace
> > to version 18 on test tablespace
> >
> > -thx,
> > avsrk
>
> Hi,
>
> I have to admit that I don't really understand what you mean with version 17
> / 18,
> but what about
> 'insert into <table at tablespace users> select * from <table at tablespace
> test>'.
> That will work when you set up object privileges properly.
>
> Please excuse me if I didn't get the point.
>
> hth + greetings,
> Guido
Received on Thu Mar 20 2003 - 15:48:31 CET