Timeline for Oracle data pump export / import errors
Current License: CC BY-SA 3.0
13 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 20, 2017 at 11:21 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Feb 15, 2017 at 4:18 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jan 13, 2017 at 0:41 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Dec 7, 2016 at 8:50 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Sep 29, 2016 at 17:25 | answer | added | Matt King | timeline score: 1 | |
| Sep 27, 2016 at 17:09 | comment | added | Matt King | I submitted a ticket to AWS and recieved this back. "It appears that RDS does not support the use of that particular stored procedure referenced in your stored procedure. As such you'll need to exclude the calling procedure with draws upon the "RDS restricted DDL found: ALTER VIEW SYS.ALL_CAPTURE" So, I'll continue to talk with them and hoping to figure out how to eliminate a stored procedure. | |
| Sep 27, 2016 at 7:38 | comment | added | Philᵀᴹ | @Gandolf989 Basically what I have said - read the link I posted | |
| Sep 26, 2016 at 20:28 | comment | added | Gandolf989 | I wonder if the issue is that you have a RDS database. Do you really have access to the physical disk with RDS? Since you are using data pump you need to write to a database directory. If you are testing the data pump process you can also just create a database directory and try to write a simple file using utl_file to see if you can do that. Because if you can't get utl_file to work data pump won't work. Another option is to use the older export and import, which can run from another machine and doesn't require a database directory. | |
| Sep 26, 2016 at 17:23 | comment | added | mustaccio |
May be you need to exclude the SYS schema from the export (surely you don't have any user objects in that schema, right?)
|
|
| Sep 26, 2016 at 15:12 | history | edited | Philᵀᴹ |
edited tags
|
|
| Sep 26, 2016 at 15:12 | review | First posts | |||
| Sep 26, 2016 at 19:28 | |||||
| Sep 26, 2016 at 15:11 | comment | added | Philᵀᴹ | Have you followed this? docs.aws.amazon.com/AmazonRDS/latest/UserGuide/… and used DBMS_FILE_TRANSFER to copy the exported dump file to the Amazon RDS instance ? | |
| Sep 26, 2016 at 15:07 | history | asked | Matt King | CC BY-SA 3.0 |