Re: copy tablespace in one database

Wojciech Skrzynecki wrote:
> Hello
>
> I plan to copy data from all tables to the new tables in new
> tablespace every night. Why? Old tablespaces will be purged every
> night and I have to have old date
>
> I think that I have two options:
>
> First
>
> I have to copy tablespace to the new with new name plus date e.g.
> tablespace "name" to the new name_date.
>
> Second:
>
> Create tables in new tablespace "as select" but what can I do with
> indexes?
>
> I do not know if first options is possible.
>
> Maybe you have any idea to help me.
>
> Rgds.
>
> Wojtek
>

May be it is acceptable to you just to rename old tables to whatever you want and provide new tables with proper/previous names. Providing that you always change all names on a particular tablespace, you could use them interchangeably.
While this is not the exact solution of your project, still those activities don't need so much time (i.e. delays in system functioning). Another possibility is using partitioning (even with one partition and of course if you have proper license) and exchange partition feature. After exchange you can simply transfer the data to another tablespace without (almost, IO still must be done) affecting the system functioning at all

Regards
Remigiusz

-- 

------------------------------------------------------------------------
Remigiusz Sokolowski <rems_at_wp-sa.pl>
WP/PTI/DIP/ZAB (+04858) 52 15 770
MySQL v04.x,05.x; Oracle v10.x

Zastrzezenia:
1. Wylaczenie danej funkcjonalnosci oznacza, ze niezwlocznie przystapimy
   lub juz pracujemy nad jej uruchomieniem
2. Niniejsza wiadomosc stanowi jedynie wyraz prywatnych pogladow autora 
   i nie jest w zadnym wypadku zwiazana ze stanowiskiem przedsiebiorstwa 
   Wirtualna Polska S.A.
------------------------------------------------------------------------



"WIRTUALNA POLSKA" Spolka Akcyjna z siedziba w Gdansku przy ul.
Traugutta 115 C, wpisana do Krajowego Rejestru Sadowego - Rejestru
Przedsiebiorcow prowadzonego przez Sad Rejonowy Gdansk - Polnoc w
Gdansku pod numerem KRS 0000068548, o kapitale zakladowym
67.980.024,00  zlotych oplaconym w calosci oraz Numerze Identyfikacji
Podatkowej 957-07-51-216.
--
http://www.freelists.org/webpage/oracle-l