IMPORT

[big]

 Hi,
On 11.2.0.4 on AIX

What are the best practice ( 'options') for  a full export?
What are the best practice ( 'options') for Importing the dump of a full export?

Should we create the table spaces in target before importing?

Thanks.

[ErmanArslansOracleBlog]

Check the following oracle presentation..

https://www.oracle.com/a/tech/docs/oracle-database-utilities-data-pump-bp-2019.pdf

There, you will see the best practices like having a consistent export, using parallelism, excluding statistics and so on.

[big]

Thanks Erman.

Just last question:

Should we create the table spaces in target before importing?

Regards.

[ErmanArslansOracleBlog]

You don't need to precreate anything if you don't want to. 

13 Şub 2021 Cmt 17:32 tarihinde big [via Erman Arslan's Oracle Forum] <[hidden email]> şunu yazdı:

Thanks Erman.

Just last question:

Should we create the table spaces in target before importing?

Regards.

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/IMPORT-tp9364p9366.html

To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

[ErmanArslansOracleBlog]

Note that, if doing a schema mode import ,  you need to create tablespaces, as a schema mode import wont create them..

13 Şub 2021 Cmt 18:51 tarihinde ErmanArslansOracleBlog [via Erman Arslan's Oracle Forum] <[hidden email]> şunu yazdı:

You don't need to precreate anything if you don't want to. 

13 Şub 2021 Cmt 17:32 tarihinde big [via Erman Arslan's Oracle Forum] <[hidden email]> şunu yazdı:

Thanks Erman.

Just last question:

Should we create the table spaces in target before importing?

Regards.

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/IMPORT-tp9364p9366.html

To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/IMPORT-tp9364p9367.html

To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML