APPS_TS_QUEUES

[Linda]

Hi!

Have you ever tried to rebuild APPS_TS_QUEUES tablespace ?
We have something like 70G, after cleaning the objects ->1G, but cannot resize.
So, we are planning move tables & queues to the temp , drop  and re-create apps_ts_queues and move back....

Br,Linda

[ErmanArslansOracleBlog]

Hi Linda,

Take a look at this note in oracle support, and use the related info in your scenario.

 ID:388672.1 How to Reorganize Workflow Tables.

12 Eyl 2014 15:38 tarihinde "Linda [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

Hi!

Have you ever tried to rebuild APPS_TS_QUEUES tablespace ?
We have something like 70G, after cleaning the objects ->1G, but cannot resize.
So, we are planning move tables & queues to the temp , drop  and re-create apps_ts_queues and move back....

Br,Linda

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/APPS-TS-QUEUES-tp34.html

To start a new topic under EBS 12.1/12.0, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

[Maaz Khan]

Hi Linda,

I have been working on similar space issue and substantial information has been captured under thread below -

https://community.oracle.com/message/15435433#15435433

You can have a look and check if its applicable to your environment.


Regards,
Maaz