Dropping empty Peoplesoft Oracle tables?

[dba]

Hello. We have Peoplesoft's payroll package. We would like to drop the 1400 empty application (&quot;ps_.....) tables in it that support aspects of the application which we do not own. We get no encouragement from Peoplesoft on this issue. Does anyone out there have any experience / insight on this. Thanks. <br>
<br>
--- dba<br>

 

[MikeLacey]

Hi DBA,<br>
<br>
Just dropping the tables is probably a bit risky and I'm not surprised that Peoplesoft are unsupportive.<br>
<br>
What you could do is:<br>
<br>
1) Create another tablespace with it's own data file - a real small one that is set to grow as it needs.<br>
<br>
2) Put all these tables into the new TS.<br>
<br>
The you could probably manage the active tables and other bits a little more easily.<br>
<br>
Mike <p>Mike Lacey<br><a href=mailto:Mike_Lacey@Cargill.Com>Mike_Lacey@Cargill.Com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>

 

[Guest_imported]

Some Peoplesoft tables are used temporarily and then emptied - so it is risky to just delete empty ones.