Rdsadmin.rdsadmin_s3_tasks.download_from_s3 Prefix

0 views

Skip to first unread message

Kum Alcini

unread,

Jul 22, 2024, 8:47:45 AM7/22/24

to dersrodtheta

The following example uploads all of the files with the prefix db in the DATA_PUMP_DIR directory to the Amazon S3 bucket named mys3bucket. Amazon RDS applies the highest level of GZIP compression to the files.

rdsadmin.rdsadmin_s3_tasks.download_from_s3 prefix

Rdsadmin.rdsadmin_s3_tasks.download_from_s3 Prefix ✓ https://tlniurl.com/2zDqfz

A flag that determines whether the task raises an error when no objects in the Amazon S3 bucket match the prefix. If this parameter is not set or set to FALSE (default), the task prints a message that no objects were found, but doesn't raise an exception or fail. If this parameter is TRUE, the task raises an exception and fails.

For example, suppose that an Amazon S3 bucket has the folder structure folder_1/folder_2/folder_3. You specify the 'folder_1/folder_2/' prefix. In this case, only the files in folder_2 are downloaded, not the files in folder_1 or folder_3.

The following example downloads all of the files with the prefix db in the Amazon S3 bucket named mys3bucket to the DATA_PUMP_DIR directory. The files are compressed with GZIP, so decompression is applied. The parameter p_error_on_zero_downloads turns on prefix error checking, so if the prefix doesn't match any files in the bucket, the task raises and exception and fails.

The following example downloads all of the files in the folder myfolder/ in the Amazon S3 bucket named mys3bucket to the DATA_PUMP_DIR directory. Use the p_s3_prefix parameter to specify the Amazon S3 folder. The uploaded files are compressed with GZIP, but aren't decompressed during the download.

To upload files to a specific folder in S3, use the p_s3_prefix parameter in the rdsadmin.rdsadmin_s3_tasks.upload_to_s3 procedure. Be sure that you have the required permissions before you upload the files.

All my RDS have the same configurations working fine. Just one brand new created was giving the error when using rdsadmin.rdsadmin_s3_tasks.download_from_s3. Reading the AWS page on RDS oracle S3 integration, I decided to remove the option S3_INTEGRATION, then I removed the IAM role and rebooted the RDS. Then, I added the same IAM and then the option S3_INTEGRATION back. Works just fine now.