Home » RDBMS Server » Performance Tuning » Related to data base import
Related to data base import [message #479174] Thu, 14 October 2010 22:29 Go to next message
rajik86ece
Messages: 5
Registered: October 2010
Junior Member
Iam doing import and export of database.
Before loading data i drop all the tables and import.
Is there any issue if we do drop tables and import data frequently.

Report message to a moderator

Re: Related to data base import [message #479176 is a reply to message #479174] Thu, 14 October 2010 22:34 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Is there any issue if we do drop tables and import data frequently.
It can clutter up the RECYCLEBIN; depending upon Oracle version.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Related to data base import [message #479198 is a reply to message #479174] Fri, 15 October 2010 02:19 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
I think it is just a silly waste of time and need frequent application downtime without speaking about humans that will lead to lost of availability if not data.

Regards
Michel

Report message to a moderator

Previous Topic: How we do Optimisation and tuning
Next Topic: (probably) basic CBO question
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 25 13:59:29 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.