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

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL function to create a table in alternate tablespace

Re: PL/SQL function to create a table in alternate tablespace

From: Brad K <koehlerb_at_NO.SPAM.w-link.net>
Date: Tue, 10 Nov 1998 06:13:58 -0800
Message-ID: <729hol$acs$1@spy.aspentec.com> 





You can do this with a SELECT INTO statement. This will copy the table
schema and the data. I think you can further specify the data to be copied
with a WHERE clause.



Also look into a COPY function that exists in SQL*Plus




Received on Tue Nov 10 1998 - 08:13:58 CST












Original text of this message













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