No question at this time
DBA Top 10
1 A. Kavsek 8600
2 M. Cadot 7200
3 B. Vroman 6200
4 T. Boles 4550
5 J. Schnackenberg 4100
6 P. Wisse 3200
7 T. P 1200
8 G. Lambregts 1100
8 . Lauri 1100
10 R. Pattyn 800
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48373
Total active users1542
Act. users last 24h7
Act. users last hour0
Registered user hits last week192
Registered user hits last month1051
Go up

datapump and dbfs
Next thread: Monthly Table Partition Export (datapump)
Prev thread: Updates failed but select works fine - For query having packaged function in where clause

Message Score Author Date
I have a restored 12.1 database that holds dbfs st...... Alain Bourgeois Mar 16, 2019, 15:52
Hi Alain, you already got a reply from Oracle s...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Ales Kavsek Mar 17, 2019, 23:23

Follow up by mail Click here


Subject: datapump and dbfs
Author: Alain Bourgeois, Belgium
Date: Mar 16, 2019, 15:52, 67 days ago
Os info: oracle enterprise linux 6
Oracle info: 12.2EE RAC and 12.1 EE RAC
Message: I have a restored 12.1 database that holds dbfs stuff. I would like to migrate some of the dbfs stuff into another database 12.2 using datapump.
I first created the tablespace in 12.2.

I created a dblink in 12.2 database to 12.1 database (as system) and imported using impdp sys as sysdba over the dblink.

At impdp level, no error displayed, table STAGING_... is created (with all rows) BUT files are not exposed as file system. The file system is not even exposed to client.

I tried to pre-create the dbfs file system, the filesystem is then exposed to dbfs client. Then I ran impdp, table STAGING_... is imported, but files are not present in the filesystem.


Question: is there any way to use impdp to import dbfs stuff????

Thank you.
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: datapump and dbfs
Author: Ales Kavsek, Slovenia
Date: Mar 17, 2019, 23:23, 65 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hi Alain,

you already got a reply from Oracle support:

https://community.oracle.com/thread/4198743

...so, the answer is no, you can’t use datapump.

regards,
ales

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here