Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How to import IMPDP without a tablespace

2025-01-18 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to import IMPDP without a tablespace, which is very detailed and has certain reference value. Friends who are interested must finish reading it!

TRANSFORM

Some tablespaces are different when importing and exporting. For example, when exporting, the object is in table space A, and if it is imported into another library without table space A, an error will be reported. However, using this parameter will import normally, and the object will be stored in the default tablespace under the user.

Commonly used TRANSFORM=segment_attributes:n

[oracle@db ~] $impdp-help | grep TRANSFORM-A2

TRANSFORM

Metadata transform to apply to applicable objects.

Valid keywords are: OID, PCTSPACE, SEGMENT_ATTRIBUTES and STORAGE.

TRANSFORM = transform_name:value [: object_type]

Transform_name

SEGMENT_ATTRIBUTES-If the value is specified as y, then segment attributes (physical attributes, storage attributes, tablespaces, and logging) are included, with appropriate DDL. The default is y.

If the value is specified as y, the segment properties (physical properties, storage properties, tablespaces, and logging) are included, along with the appropriate DDL. The default value is y.

STORAGE-If the value is specified as y, then the storage clauses are included, with appropriate DDL. The default is y. This parameter is ignored if SEGMENT_ATTRIBUTES=n.

If the value is specified as y, the storage clause is included and the appropriate DDL is used. The default value is y. If SEGMENT_ATTRIBUTES = n, this parameter is ignored

OID-If the value is specified as n, then the assignment of the exported OID during the creation of object tables and types is inhibited. Instead, a new OID is assigned. This can be useful for cloning schemas, but does not affect referenced objects. The default value is y.

If the value is specified as n, the allocation of exported OID is prohibited during the creation of object tables and types. Instead, a new OID is assigned. This is useful for cloning patterns, but does not affect referenced objects. The default value is y.

PCTSPACE-The value supplied for this transform must be a number greater than zero. It represents the percentage multiplier used to alter extent allocations and the size of data files.

The value provided for this conversion must be a number greater than zero. It represents the percentage multiplier used to change the range allocation and datafile size.

Value

The type of value specified depends on the transform used. Boolean values (YBO) are required for the SEGMENT_ATTRIBUTES, STORAGE, and OID transforms. Integer values are required for the PCTSPACE transform.

The type of value specified depends on the conversion used. The SEGMENT_ATTRIBUTES,STORAGE and OID transformations require a Boolean value (y / n). The PCTSPACE transformation requires an integer value.

Object_type

The object_type is optional. If supplied, it designates the object type to which the transform will be applied. If no object type is specified, then the transform applies to all valid object types. The valid object types are TABLE 、 INDEX 、 CLUSTER 、 TABLESPACE...

Object_type is optional. If provided, specifies the type of object to which the transformation will be applied. If no object type is specified, the conversion is applied to all valid object types. The valid object type is TABLE,INDEX,CLUSTER,TABLESPACE.

The above is all the content of the article "how to import IMPDP without a tablespace". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report