Re: storage clause help !!!!

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 30 Dec 1999 11:31:58 -0500
Message-ID: <r52n6scabm6g37vgcron78qfhncaqat331@4ax.com>

A copy of this was sent to Serge Nantel <snantel_at_sympatico.ca> (if that email address didn't require changing) On Thu, 30 Dec 1999 15:56:16 GMT, you wrote:

>Help I need a script to retrieve all the storage clause from a Oracle
>database 7.3.x can some one help me with this!
>
>Thank you kindly
>snantel_at_sympatico.ca
>
>

exp/imp can do this for you. the following shows how to do this for the EMP table in the SCOTT schema. you can do this for any number of tables or users or the whole database.

$ exp userid=scott/tiger tables=emp rows=n

Export: Release 7.3.4.0.0 - Production on Thu Dec 30 11:34:42 1999

Connected to: Oracle7 Server Release 7.3.4.0.1 - Production With the distributed, parallel query and Spatial Data options PL/SQL Release 2.3.4.0.0 - Production
Export done in US7ASCII character set
Note: table data (rows) will not be exported

About to export specified tables via Conventional Path ...

. . exporting table                            EMP

Export terminated successfully without warnings.

$ imp userid=scott/tiger full=y show=y

Import: Release 7.3.4.0.0 - Production on Thu Dec 30 11:34:49 1999

Connected to: Oracle7 Server Release 7.3.4.0.1 - Production With the distributed, parallel query and Spatial Data options PL/SQL Release 2.3.4.0.0 - Production

Export file created by EXPORT:V07.03.04 via conventional path . importing SCOTT's objects into SCOTT

 "CREATE TABLE "EMP" ("EMPNO" NUMBER(4, 0) NOT NULL, "ENAME" VARCHAR2(10), "J"
 "OB" VARCHAR2(9), "MGR" NUMBER(4, 0), "HIREDATE" DATE, "SAL" NUMBER(7, 2), ""
 "COMM" NUMBER(7, 2), "DEPTNO" NUMBER(2, 0))  PCTFREE 10 PCTUSED 40 INITRANS "
 "1 MAXTRANS 255 STORAGE(INITIAL 16384 NEXT 16384 MINEXTENTS 1 MAXEXTENTS 505"
 " PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM""

Import terminated successfully without warnings.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Dec 30 1999 - 10:31:58 CST