OraFAQ Forum: SQL & PL/SQL » PL SQL - Need to create archive table

Home » SQL & PL/SQL » SQL & PL/SQL » PL SQL - Need to create archive table - [MERGED]

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

PL SQL - Need to create archive table - [MERGED] [message #638633]

Tue, 16 June 2015 05:51

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

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

OK, do it.

Report message to a moderator

Re: PL SQL - Need to create archive table [message #638637 is a reply to message #638633]

Tue, 16 June 2015 06:03

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Why

Report message to a moderator

Re: PL SQL - Need to create archive table [message #638638 is a reply to message #638633]

Tue, 16 June 2015 06:24

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.

Report message to a moderator

Re: PL SQL - Need to create archive table [message #638639 is a reply to message #638638]

Tue, 16 June 2015 06:27

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

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).

Report message to a moderator

Re: PL SQL - Need to create archive table [message #638655 is a reply to message #638639]

Wed, 17 June 2015 01:36

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?

Report message to a moderator

Re: PL SQL - Need to create archive table [message #638656 is a reply to message #638655]

Wed, 17 June 2015 01:42

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Aug 22 12:48:31 CDT 2026