Home » RDBMS Server » Server Administration » Cloning database - Recreate undo (Oracle 9i, AIX)
Cloning database - Recreate undo [message #353884] Wed, 15 October 2008 08:00 Go to next message
psoftneto
Messages: 44
Registered: July 2008
Member
Hi all,

I need to clone database A to database B.
I don't have enough space for undo datafiles in server for database B.
Can I create directly undo tablespace and datafiles on database B ? How ?

Thanks for your help.
Re: Cloning database - Recreate undo [message #353888 is a reply to message #353884] Wed, 15 October 2008 08:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Can I create directly undo tablespace and datafiles on database B ? How ?

Using CREATE UNDO TABLESPACE?

Regards
Michel
Re: Cloning database - Recreate undo [message #353937 is a reply to message #353884] Wed, 15 October 2008 13:50 Go to previous messageGo to next message
psoftneto
Messages: 44
Registered: July 2008
Member
If the undo datafile is created with an initial size and autoextend on.
Will the size of the datafile always return to initial size whenever we shutdown the database ?
Even if at a certain time the datafile exceed the initial size ?

Thanks
Re: Cloning database - Recreate undo [message #353938 is a reply to message #353937] Wed, 15 October 2008 13:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Will the size of the datafile always return to initial size whenever we shutdown the database ?

No, never.

Regards
Michel
Re: Cloning database - Recreate undo [message #354321 is a reply to message #353884] Fri, 17 October 2008 13:37 Go to previous message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Decide how you going to clone this database ?
Previous Topic: More Space after Deleting Data
Next Topic: materialized views
Goto Forum:
  


Current Time: Sun Dec 04 22:31:34 CST 2016

Total time taken to generate the page: 0.14370 seconds