Home » RDBMS Server » Server Administration » Cleaning Database after development and tests (12.1.0.2-Win2012)
Cleaning Database after development and tests [message #663771] Sat, 17 June 2017 03:24 Go to next message
fabi88
Messages: 112
Registered: November 2011
Senior Member
Hi,

There is a Database which have more than 4 TB data in development and test phases, Now, Database should be cleaned for using in production environment.
Is sufficient that only truncate tables?
What should be done in this situation?

Many thanks in advance.
Regards.
Re: Cleaning Database after development and tests [message #663773 is a reply to message #663771] Sat, 17 June 2017 04:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You should have the scripts to create the users, their objects and privileges and so on, so the fastest clean way will be to drop the database and recreate it.

[Updated on: Sat, 17 June 2017 04:44]

Report message to a moderator

Re: Cleaning Database after development and tests [message #663774 is a reply to message #663773] Sat, 17 June 2017 07:53 Go to previous messageGo to next message
fabi88
Messages: 112
Registered: November 2011
Senior Member
Thank you so much for helpful reply.
Re: Cleaning Database after development and tests [message #663775 is a reply to message #663771] Sat, 17 June 2017 07:54 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Is sufficient that only truncate tables?

If you TRUNCATE "lookup" table, it will most likely break the application.
Re: Cleaning Database after development and tests [message #663776 is a reply to message #663771] Sat, 17 June 2017 13:18 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
. . . and once you follow the advice of others and get your 'clean' database, you might be well advised to use rman to take an offline, archival backup of it, so that you can fall back to that at any time.
Re: Cleaning Database after development and tests [message #663780 is a reply to message #663776] Sun, 18 June 2017 12:20 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I understood, that's the only database you have. Does it mean that further development and testing is stopped? Because, are you really going to use the same database for that purposes? If so, is it a good idea? Why don't you have a separate database(s)?
Re: Cleaning Database after development and tests [message #663857 is a reply to message #663780] Wed, 21 June 2017 08:00 Go to previous messageGo to next message
fabi88
Messages: 112
Registered: November 2011
Senior Member
Thank you for your replies.
Quote:

As far as I understood, that's the only database you have. Does it mean that further development and testing is stopped? Because, are you really going to use the same database for that purposes? If so, is it a good idea? Why don't you have a separate database(s)?
Same database will be created before moving database to production environment for further development on test server.

Re: Cleaning Database after development and tests [message #663861 is a reply to message #663857] Wed, 21 June 2017 08:31 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
And where will you be doing your testing?
Re: Cleaning Database after development and tests [message #663875 is a reply to message #663857] Thu, 22 June 2017 06:49 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
fabi88 wrote on Wed, 21 June 2017 08:00
Thank you for your replies.

Same database will be created before moving database to production environment for further development on test server.

That's a confusing statement. You cannot create the "same" database. You can create a new database with the same name, structure, and data, but it will have a different dbid, and it will be a different database. Please clarify your usage of the current database (the one you want to "clean") and future copies/replicas/duplications of that database.

Re: Cleaning Database after development and tests [message #663913 is a reply to message #663875] Sun, 25 June 2017 05:52 Go to previous message
fabi88
Messages: 112
Registered: November 2011
Senior Member
Quote:
You can create a new database with the same name, structure, and data, but it will have a different dbid, and it will be a different database.
Yes, that is true.

I mean that just same structure. Some change will be applied on test database (for example add/modify a procedure), after that it will be applied on production database.
Previous Topic: creating a database link between 12c and 8i
Next Topic: AD Domain Group - Windows
Goto Forum:
  


Current Time: Thu Mar 28 06:00:08 CDT 2024