I am trying to create a tablespace within an Oracle database through a PHP application using IIS 6.0.
In my php.ini I uncommented extension=php_oci8.dll and I set my extension_dir. I also copied this file to c:\windows.
I added the IIS_WPG user to the ora10g\bin, oradata\DB, and the PHP application folder.
I add the IUSR_compname to oradata\DB, php application folder, ora10g\bin, tnsnames, and php\extensions.
I created the following Environment Variables: ORACLE_HOME, ORACLE_SID, and TNS_ADMIN.
When I look at phpinfo in a browser it says OCI8 Support is enabled.
My problem occurs when I try to create a tablespace. I don't get an error, it just breaks on the following line:
if (!$dbora->Execute("CREATE TABLESPACE ".$schema." DATAFILE
'".$path."\".$schema.".DBF' SIZE 2M AUTOEXTEND ON NEXT 2M MAXSIZE UNLIMITED
LOGGING
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT MANUAL
FLASHBACK ON
")) return "Create Tablespace";
I have it returning "Create Tablespace" so I could determine where it was breaking.
Any ideas?
