共計(jì) 1985 個(gè)字符，預(yù)計(jì)需要花費(fèi) 5 分鐘才能閱讀完成。

這篇文章主要介紹 IMPDP 如何導(dǎo)入沒有某個(gè)表空間，文中介紹的非常詳細(xì)，具有一定的參考價(jià)值，感興趣的小伙伴們一定要看完！

TRANSFORM

導(dǎo)入和導(dǎo)出的時(shí)候，有些表空間不一樣。比如導(dǎo)出的時(shí)候該對(duì)象是在 A 表空間，導(dǎo)入到另一個(gè)庫沒有表空間 A 就會(huì)報(bào)錯(cuò)。但是使用這個(gè)參數(shù)就會(huì)正常導(dǎo)入，該對(duì)象會(huì)存儲(chǔ)在該用戶下的默認(rèn)表空間中。

常用 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.

如果將值指定為 y，則包含段屬性（物理屬性，存儲(chǔ)屬性，表空間和日志記錄）以及適當(dāng)?shù)?DDL。默認(rèn)值為 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.

如果將值指定為 y，則包含存儲(chǔ)子句，并使用適當(dāng)?shù)?DDL。默認(rèn)值為 y。如果 SEGMENT_ATTRIBUTES = n，則忽略此參數(shù)

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.

如果將值指定為 n，則禁止在創(chuàng)建對(duì)象表和類型期間分配導(dǎo)出的 OID。而是分配新的 OID。這對(duì)于克隆模式很有用，但不會(huì)影響引用的對(duì)象。默認(rèn)值為 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.

為此轉(zhuǎn)換提供的值必須是大于零的數(shù)字。它表示用于更改范圍分配和數(shù)據(jù)文件大小的百分比乘數(shù)。

value

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

指定的值類型取決于使用的轉(zhuǎn)換。SEGMENT_ATTRIBUTES，STORAGE 和 OID 轉(zhuǎn)換需要布爾值（y / n）。PCTSPACE 轉(zhuǎn)換需要整數(shù)值。

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 是可選的。如果提供，則指定將應(yīng)用變換的對(duì)象類型。如果未指定任何對(duì)象類型，則轉(zhuǎn)換將應(yīng)用于所有有效對(duì)象類型。有效的對(duì)象類型是 TABLE，INDEX，CLUSTER，TABLESPACE ……

以上是“IMPDP 如何導(dǎo)入沒有某個(gè)表空間”這篇文章的所有內(nèi)容，感謝各位的閱讀！希望分享的內(nèi)容對(duì)大家有幫助，更多相關(guān)知識(shí)，歡迎關(guān)注丸趣 TV 行業(yè)資訊頻道！