OraFAQ Forum: Server Administration » Tablespace creation (merged 3)

Home » RDBMS Server » Server Administration » Tablespace creation (merged 3) (Database,10.2.0.3,Windows 2003 server 64 bit itanium)

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

Tablespace creation (merged 3) [message #558569]

Sun, 24 June 2012 03:38

eafaisal
Messages: 12
Registered: November 2011

Junior Member

Problem Description: There are five range partitioned tables which are partitioned by date,designed by previous DBA.Four tables are in one tablespace and one more table is in another tablespace.For every three months there are two tablespaces are created autamatically in new names for future dates.There is no scheduled job for this.How they are created?.This is our question.

Report message to a moderator

Re: Tablespace creation [message #558571 is a reply to message #558569]

Sun, 24 June 2012 04:05

Michel Cadot
Messages: 68637
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Your answer is that something is creating them (maybe a trigger).
Oracle does NOT create partitions or tablespaces by itself.

Regards
Michel

Report message to a moderator

Tablespace creation [message #558572 is a reply to message #558569]

Sun, 24 June 2012 05:32

eafaisal
Messages: 12
Registered: November 2011

Junior Member

Report message to a moderator

Re: Tablespace creation [message #558573 is a reply to message #558572]

Sun, 24 June 2012 05:35

Michel Cadot
Messages: 68637
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Why do you repost the same question when I answered you an hour and half ago to the previous one(s)?

Regards
Michel

Report message to a moderator

Previous Topic:	database installation
Next Topic:	Undo info of insert statement

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 12:52:50 CDT 2024