Home » RDBMS Server » Server Administration » Tablespace creation (merged 3) (Database,10.2.0.3,Windows 2003 server 64 bit itanium)
Tablespace creation (merged 3) [message #558569] Sun, 24 June 2012 03:38 Go to next message
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.
Re: Tablespace creation [message #558571 is a reply to message #558569] Sun, 24 June 2012 04:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68045
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
Tablespace creation [message #558572 is a reply to message #558569] Sun, 24 June 2012 05:32 Go to previous messageGo to next message
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.
Re: Tablespace creation [message #558573 is a reply to message #558572] Sun, 24 June 2012 05:35 Go to previous message
Michel Cadot
Messages: 68045
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
Previous Topic: database installation
Next Topic: Undo info of insert statement
Goto Forum:
  


Current Time: Fri Dec 03 22:03:21 CST 2021