Home » SQL & PL/SQL » SQL & PL/SQL » PL SQL - Need to create archive table - [MERGED]
PL SQL - Need to create archive table - [MERGED] [message #638633] Tue, 16 June 2015 05:51 Go to next message
rajivgandhiram
Messages: 1
Registered: June 2015
Location: Chennai
Junior Member
Need to create archive table (except last two year data) from more than 2000 table using dynamic plsql program.

we need to pass fields and column name dynamically.


Lalit : Topic merged with "We need to get backup from 2000 Table except last twp years dynamically"

[Updated on: Wed, 17 June 2015 01:40] by Moderator

Report message to a moderator

Re: PL SQL - Need to create archive table [message #638636 is a reply to message #638633] Tue, 16 June 2015 05:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

OK, do it.

Re: PL SQL - Need to create archive table [message #638637 is a reply to message #638633] Tue, 16 June 2015 06:03 Go to previous messageGo to next message
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
Senior Member
Why
Re: PL SQL - Need to create archive table [message #638638 is a reply to message #638633] Tue, 16 June 2015 06:24 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Welcome to the forum!

Please read and follow the OraFAQ Forum Guide and How to use [code] tags, to enable us to help you.

rajivgandhiram wrote on Tue, 16 June 2015 16:21
Need to create archive table (except last two year data) from more than 2000 table using dynamic plsql program.


What it has to do with PL/SQL? You don't create objects on the fly programmatically.
Re: PL SQL - Need to create archive table [message #638639 is a reply to message #638638] Tue, 16 June 2015 06:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Maybe it is just an "INSERT /*+ APPEND */ INTO <archive> SELECT * FROM <current>", no need to create archive table on the fly.
And no need of dynamic column names, just table names (to replace <> place holders).

Re: PL SQL - Need to create archive table [message #638655 is a reply to message #638639] Wed, 17 June 2015 01:36 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
What did you understand from Michel's reply above?
Re: PL SQL - Need to create archive table [message #638656 is a reply to message #638655] Wed, 17 June 2015 01:42 Go to previous message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
@rajivgandhiram,

Don't create multiple topics for the same question. Use the current thread for discussion.

[Mod Edit] I removed the duplicate posts.

[Updated on: Wed, 17 June 2015 02:53] by Moderator

Report message to a moderator

Previous Topic: Create VIEW retrieving from dynamically configured table/queries
Next Topic: dynamic input value passing
Goto Forum:
  


Current Time: Thu Mar 28 20:18:59 CDT 2024