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

Hi Steve,

I recommend reading ORACLE PL/SQL Programming from Steven Feuerstein (O'Reilly ISBN 1-56592-142-9)

• eSPri ==

Steve Keider wrote:

> Hi.
>
> I am pretty new to Oracle and PL/SQL, and am having a hard time
> finding documentation with good examples.
>
> 1. I would like to create a Procedure which drops a table in my
> warehouse tablespace and then recreates it from the source tables.
> I think the code should be something like this.
>
> CREATE OR REPLACE FUNCTION create_whtable
> IS
> BEGIN
> DROP TABLE FA_DBA.FARS;
> CREATE TABLE whtable TABLESPACE warehouse_data SELECT * FROM
> sourceview;
> END;
> /
>
> 2. I then would like to schedule this procedure to be run once a week
> using the DBMS_JOB package, but I have no idea how to use this
> package.
>
> Any help would be much appreciated
>
> TIA,
>
> Steve Keider
Received on Wed Nov 04 1998 - 03:11:52 CST