Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Why does CREATE SNAPSHOT use the DEFAULT tbsp ??

Re: Why does CREATE SNAPSHOT use the DEFAULT tbsp ??

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 16 Jan 2001 21:42:05 -0800
Message-ID: <3A6530AC.67193D79@exesolutions.com>

> I'd just like to know why this command uses (temporarily
> I guess) the schema's that's creating the snapshot default
> tablespace. I got the following error when running the
> statement:
> > connect myLogin/myPsswd
> > CREATE SNAPSHOT <..> TABLESPACE tbsp_x AS
> > SELECT * FROM scott.emp_at_myDb_link;
> >
> > ERROR at line 1:
> > ORA-01659: unable to allocate MINEXTENTS beyond 1 in
> > tablespace tbsp_z
>
> OK I managed to solve this by adding a datafile to my
> TBSP_Z tablespace, but it's not the one specified in the
> SQL statement... (it's myLogin's default tablespace)
>
> What does Oracle use it for ??

A snapshot is just a normal table with the code required for regular refreshing. It puts the table, and its indexes in the default tablespace unless you specify otherwise (which you should do at least with respect to the indexes).

Daniel A. Morgan Received on Tue Jan 16 2001 - 23:42:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US