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: 77
Registered: November 2011
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: 65155
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: 77
Registered: November 2011
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: 25581
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: 820
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: 21151
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: 77
Registered: November 2011
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: 883
Registered: November 2010
Location: Bristol, 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: 820
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: 77
Registered: November 2011
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: transportable tablespace RHEL to Solaris
Next Topic: AD Domain Group - Windows
Goto Forum:
  


Current Time: Thu Aug 24 01:59:26 CDT 2017

Total time taken to generate the page: 0.05533 seconds