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.

Report message to a moderator

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: 68666
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

Report message to a moderator

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

Report message to a moderator

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: 68666
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

Report message to a moderator

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 ?

Report message to a moderator

Previous Topic: More Space after Deleting Data
Next Topic: materialized views
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jul 07 23:25:41 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.