
I have started to migrate some database On-Prem to AWS RDS. I have been migration Oracle On-Prem to AWS Oracle RDS which means that it will be a Homogeneous migration process.
Then as one of the steps to migrate this database, I have taken all the DDL of the tablespaces On-Prem and decided to create in my target RDS database. Therefore, in the creation process I stuck in this error:
SQL> CREATE TABLESPACE "TECHDATABASKETTBS" DATAFILE '/rdsdbdata/db/techdatabasket/datafile/techdatabasket01.dbf' SIZE 1073741824, '/rdsdbdata/db/techdatabasket/datafile/techdatabasket04.dbf' SIZE 17179869184, '/rdsdbdata/db/techdatabasket/datafile/techdatabasket03.dbf' SIZE 17179869184, '/rdsdbdata/db/techdatabasket/datafile/techdatabasket02.dbf' SIZE 17179869184, '/rdsdbdata/db/techdatabasket/datafile/techdatabasket14.dbf' SIZE 4294967296, 2 3 4 '/rdsdbdata/db/techdatabasket/datafile/techdatabasket13.dbf' SIZE 17179869184, '/rdsdbdata/db/techdatabasket/datafile/techdatabasket12.dbf' SIZE 17179869184, 5 6 7 '/rdsdbdata/db/techdatabasket/datafile/techdatabasket11.dbf' SIZE 17179869184, '/rdsdbdata/db/techdatabasket/datafile/techdatabasket10.dbf' SIZE 17179869184, '/rdsdbdata/db/techdatabasket/datafile/techdatabasket09.dbf' SIZE 17179869184, '/rdsdbdata/db/techdatabasket/datafile/techdatabasket08.dbf' SIZE 17179869184, '/rdsdbdata/db/techdatabasket/datafile/techdatabasket07.dbf' SIZE 17179869184, '/rdsdbdata/db/techdatabasket/datafile/techdatabasket06.dbf' SIZE 17179869184, 8 9 10 '/rdsdbdata/db/techdatabasket/datafile/techdatabasket05.dbf' SIZE 17179869184 LOGGING ONLINE PERMANENT BLOCKSIZE 16384 EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO; 11 12 13 14 15 16 17 18 CREATE TABLESPACE "TECHDATABASKETTBS" DATAFILE * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-20900: RDS only supports Oracle Managed Files. Check ddl and remove any named identifiers ORA-06512: at "RDSADMIN.RDSADMIN_TRIGGER_UTIL", line 235 ORA-06512: at line 2
According to Amazon documentation “Amazon RDS only supports Oracle Managed Files (OMF) for data files, log files, and control files. When you create data files and log files, you can’t specify the physical file names. “. Also, Amazon recommends the use of a Bigfile instead of Smallfile. Once when you create a Smallfile tablespace you will have to add a new datafile everytime because it is not possible to resize Smallfile tablespaces with Amazon RDS for Oracle. Then I decided to follow the recommendations and created my tablespace:
SQL> CREATE BIGFILE TABLESPACE TECHDATABASKETTBS DATAFILE SIZE 50G; Tablespace created.


*The views expressed here are my own and do not represent those of my employer.*
Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence, and hold dual Master’s degrees in Data Science and Cybersecurity. With over fifteen years of international experience spanning Brazil, Hungary, and Sweden, I have collaborated with global organizations such as IBM, Playtech, and Oracle, as well as contributed remotely to projects across multiple regions. My professional interests include Databases, Cybersecurity, Cloud Computing, Data Science, Data Engineering, Big Data, Artificial Intelligence, Programming, and Software Engineering, all driven by a deep passion for transforming data into strategic business value.
… [Trackback]
[…] Find More Information here to that Topic: techdatabasket.com/2019/11/11/oracle-and-aws-rds-for-oracle-tip-ora-20900-rds-only-supports-oracle-managed-files-check-ddl-and-remove-any/ […]
… [Trackback]
[…] Find More to that Topic: techdatabasket.com/2019/11/11/oracle-and-aws-rds-for-oracle-tip-ora-20900-rds-only-supports-oracle-managed-files-check-ddl-and-remove-any/ […]
… [Trackback]
[…] Read More here to that Topic: techdatabasket.com/2019/11/11/oracle-and-aws-rds-for-oracle-tip-ora-20900-rds-only-supports-oracle-managed-files-check-ddl-and-remove-any/ […]
… [Trackback]
[…] Info on that Topic: techdatabasket.com/2019/11/11/oracle-and-aws-rds-for-oracle-tip-ora-20900-rds-only-supports-oracle-managed-files-check-ddl-and-remove-any/ […]
… [Trackback]
[…] Info to that Topic: techdatabasket.com/2019/11/11/oracle-and-aws-rds-for-oracle-tip-ora-20900-rds-only-supports-oracle-managed-files-check-ddl-and-remove-any/ […]