Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem moving a table to another tablespace (NOT a newbie)
sec97_at_hotmail.com (Sam Cummins) wrote in message news:<yPih7.7020$Xg2.811163925_at_newssvr17.news.prodigy.com>...
> 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.
Have you tried "alter table move .." Received on Fri Aug 24 2001 - 06:48:00 CDT