Skip to content

Archive for

Apr 10

1 Comment

expdp and impdp tablespace on same database

Just a example for export tablespace and import tablespace on the same database when the tablespace existing

Step1 :

Step 2: export tabespace

Step 3: import tablespace but errors shown when it ends because of already existing objects there

Step 4: use table_exists_action=replace

Apr 4

How do you acces your local directory from Remote Desktop whenever you login windows remote desktop

This is the simple method to configure

Step 1:

open remote desktop, click options –> local resources

click more

 

Step 2:

Choose your local directory

 

Step 3:

Now login remote desktop

Step 4:

you can see your local directory at remote desktop, now you can able to copy server data to your local directory

 

 

Apr 4

Normal export exp support if table column encrypted?

Normal export exp does not support if table column encrypted using TDE method. However datapump is support.

Lets see example

Step 1:

Step 2:

 

Step 3:

Step 4: