Re: Help on partition managing

From: Marc Blum <marc_at_marcblum.de>
Date: Sat, 20 Jul 2002 10:12:00 +0200
Message-ID: <mi6ijuka78rapenj9ngiqraqp274d659h8@4ax.com>

sorrily I don't see your problem:

Oracle EE 8.1.7.2 on W2k

SQL> desc t_part

 Name                                      Null?    Type
 ----------------------------------------- -------- ---------------------------
 ROW#                                               NUMBER
 TEXT                                               VARCHAR2(4000)

SQL> select partition_name
  2 from user_tab_partitions
  3 where table_name = 'T_PART';

PARTITION_NAME

---

P2000
P3000
POWERFLOW
P1000

SQL> host exp userid=marc/marc_at_demo tables=t_part file=d:\t_part.dmp rows=n

SQL> Inside t_part.dmp I find (manually formatted for readability):

TABLE "T_PART"
CREATE TABLE "T_PART"
("ROW#" NUMBER, "TEXT" VARCHAR2(4000)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING TABLESPACE "TS_A"
PARTITION BY RANGE ("ROW#" )
(PARTITION "P1000" VALUES LESS THAN (1001)  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255  STORAGE(INITIAL 131072)
 TABLESPACE "TS_A" LOGGING,
 PARTITION "P2000" VALUES LESS THAN (1002)  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255  STORAGE(INITIAL 131072)
 TABLESPACE "TS_A" LOGGING,
 PARTITION "P3000" VALUES LESS THAN (1003)  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255  STORAGE(INITIAL 131072)
 TABLESPACE "TS_A" LOGGING,
 PARTITION "POWERFLOW" VALUES LESS THAN (MAXVALUE)  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255  STORAGE(INITIAL 131072)
 TABLESPACE "TS_A" LOGGING )
ENDPARTITION Be aware of the fact, that you don't get the original CREATE TABLE statement. All clauses not specified during creation are inherited from the tablespace settings.

hth

On Fri, 19 Jul 2002 17:05:26 GMT, u705413818_at_spawnkill.ip-mobilphone.net (Joe Bayer) wrote:

>Hi, we are using oracle 8172
>
>I used to use export with rows=n to get the dump file, and vi the dump
>file, after delete the first few lines, we can get the table re-create
>script.
>
>But if the table is partitioned, when I open the dump file with vi, I
>can not see any table re-create script even if I deleted all the lines,
>is there any way I can get the ddl of a table?
>
>When we user create table bla as select * from table A, what I got is
>unpartitioned tables, is there any convinent way to create a copy of a
>partitioned, sub-partitioned table?
>
>
>Thanks for your help
>
>
>

Marc Blum
mailto:marc_at_marcblum.de
http://www.marcblum.de Received on Sat Jul 20 2002 - 03:12:00 CDT