Home » RDBMS Server » Server Administration » confused
confused [message #205117] Thu, 23 November 2006 06:23 Go to next message
puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India
Member

hei everyone

I want to now what is this DB refresh?
I confused with thsi term

Also what is another way to change the database name, apart from creating control file by creating another control file by alter database backup control to trace.

Puneet
Re: confused [message #205125 is a reply to message #205117] Thu, 23 November 2006 06:54 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
I want to now what is this DB refresh?

Really i am also confused above word bcoz in what term refresh..

but in database you can say . Re organization. like table reorganization , move tablespace .. for aviod fragamentation.


Also what is another way to change the database name


YOu can use nid utility.


http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14215/dbnewid.htm
creating control file by creating another control file by alter database backup control to trace.


Through above you can create bkp of control file.

hope this helps
Taj.

[Updated on: Thu, 23 November 2006 07:08]

Report message to a moderator

Re: confused [message #205128 is a reply to message #205117] Thu, 23 November 2006 07:06 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> I want to now what is this DB refresh?
In conventional oracle terminology, it means refreshing the database from another database. Usually refreshing a test/dev database from the production database.
The term may also vary depending on the tool you use.
You can just refresh the data (export with rows=n) or data and objects or selected tablespaces or even a whole database (duplicate/clone in RMAN) with a full restore or recover to some point-in-time (TSPITR).
Previous Topic: creating schema
Next Topic: oracle 10g in sun solaris 10 - Prequirment for installation
Goto Forum:
  


Current Time: Thu Dec 08 06:04:05 CST 2016

Total time taken to generate the page: 0.08873 seconds