exporting a partitioned table? [message #69058] |
Mon, 22 October 2001 13:52 |
lily
Messages: 44 Registered: September 2000
|
Member |
|
|
Can anybody tell me how do i export and import a partitioned table?
thanks in advance,
lily
----------------------------------------------------------------------
|
|
|
Re: exporting a partitioned table? [message #69105 is a reply to message #69058] |
Wed, 31 October 2001 06:29 |
oraboy
Messages: 97 Registered: October 2001
|
Member |
|
|
In ur export parameters , you would normally say
TABLE= t1,t2 etc (parameter name TABLE or TABLES, I am not sure)
just extend it for partioned tables like
TABLE=t1.p1,t1.p2
(this makes to export specified partitions alone
import is as usual from dump file
----------------------------------------------------------------------
|
|
|
Re: exporting a partitioned table? [message #70173 is a reply to message #69058] |
Wed, 24 April 2002 12:22 |
ramanivishnu
Messages: 1 Registered: April 2002
|
Junior Member |
|
|
here is the sample of syntax for exporting partitioned tables:
Specifies that the Export is a table-mode Export and lists the table names and partition and subpartition names to export. You can specify the following when you specify the name of the table:
schemaname specifies the name of the user's schema from which to export the table or partition. The schema names ORDSYS, MDSYS, CTXSYS, and ORDPLUGINS are reserved by Export.
tablename specifies the name of the table or tables to be exported. Table-level export lets you export entire partitioned or nonpartitioned tables. If a table in the list is partitioned and you do not specify a partition name, all its partitions and subpartitions are exported.
The table name can contain any number of '%' pattern matching characters, which can each match zero or more characters in the table name against the table objects in the database. All the tables in the relevant schema that match the specified pattern are selected for export, as if the respective table names were explicitly specified in the parameter.
partition_name indicates that the export is a partition-level Export. Partition-level Export lets you export one or more specified partitions or subpartitions within a table.
The syntax you use to specify the preceding is in the form:
schemaname.tablename:partition_name
schemaname.tablename:subpartition_name
If you use tablename:partition_name, the specified table must be partitioned, and partition_name must be the name of one of its partitions or subpartitions. If the specified table is not partitioned, the partition_name is ignored and the entire table is exported.
|
|
|