Geetika Saini Posted October 1, 2019 Share Posted October 1, 2019 Hello Team, I am installing Spotfire 10.5 on Amazon RDS machine using Oracle express 11g database.when i am running "create_database_rds.bat" file in command prompt i am getting error. here is the error message- " Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production SQL> SQL> CREATE TABLESPACE &3 LOGGING 2 --DATAFILE SIZE 400M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED 3 / old 1: CREATE TABLESPACE &3 LOGGING new 1: CREATE TABLESPACE SPOTFIRE_DATA LOGGING --DATAFILE SIZE 400M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED * ERROR at line 2: ORA-02199: missing DATAFILE/TEMPFILE clause Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production " Can any one help me out with this error,what i can do to resolve the error. Link to comment Share on other sites More sharing options...
Prashant Anand Posted October 7, 2019 Share Posted October 7, 2019 Geethika, We saw that the oracle instance was on winows server and not on AWS server. We need to use the "create_database_bat" file in that case and not "create_database_rds_bat". Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now