Re: Problem moving a table to another tablespace (NOT a newbie)

In article <Bxjg7.3093$W6.411658423_at_newssvr17.news.prodigy.com>, tgphelps50_at_yahoo.com says...
>
>This started as a small problem, I thought, but it has become a tough nut to
>crack. I have a TAR open with Oracle, but they are NOT helpful. Here's a quick
>summary: I'm trying to move the standard Oracle table AQ$_QUEUES into the
>SYSTEM tablespace, where it belongs. I'm running 8.1.7 on AIX.

I'm the original poster of this thread. I haven't had any responses, so I suppose this isn't a simple problem. There must be some way to move this table, or if necessary recreate all the AQ tables from scratch, isn't there? If the AQ stuff is recreated by the catalog.sql script, can I simply run that script without causing any problems. But then, if I can't move this table, I suppose that no script from Oracle could either. So what would happen to me (or you) if  the AQ$_QUEUES table got corrupted? How would I ever fix it, other than restoring from a backup?

The Oracle Metalink forum I posted to hasn't been of any assistance either. Hmmm. Received on Thu Aug 23 2001 - 21:18:06 CDT