OraFAQ Forum: Server Administration » Cleaning Database after development and tests

Home » RDBMS Server » Server Administration » Cleaning Database after development and tests (12.1.0.2-Win2012)

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

Cleaning Database after development and tests [message #663771]

Sat, 17 June 2017 03:24

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.

Report message to a moderator

Re: Cleaning Database after development and tests [message #663773 is a reply to message #663771]

Sat, 17 June 2017 04:43

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

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

fabi88
Messages: 112
Registered: November 2011

Senior Member

Thank you so much for helpful reply.

Report message to a moderator

Re: Cleaning Database after development and tests [message #663775 is a reply to message #663771]

Sat, 17 June 2017 07:54

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.

Report message to a moderator

Re: Cleaning Database after development and tests [message #663776 is a reply to message #663771]

Sat, 17 June 2017 13:18

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.

Report message to a moderator

Re: Cleaning Database after development and tests [message #663780 is a reply to message #663776]

Sun, 18 June 2017 12:20

Littlefoot
Messages: 21823
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)?

Report message to a moderator

Re: Cleaning Database after development and tests [message #663857 is a reply to message #663780]

Wed, 21 June 2017 08:00

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.

Report message to a moderator

Re: Cleaning Database after development and tests [message #663861 is a reply to message #663857]

Wed, 21 June 2017 08:31

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

And where will you be doing your testing?

Report message to a moderator

Re: Cleaning Database after development and tests [message #663875 is a reply to message #663857]

Thu, 22 June 2017 06:49

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.

Report message to a moderator

Re: Cleaning Database after development and tests [message #663913 is a reply to message #663875]

Sun, 25 June 2017 05:52

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.

Report message to a moderator

Previous Topic:	creating a database link between 12c and 8i
Next Topic:	AD Domain Group - Windows

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 13:51:43 CST 2024