Oracle Database - Enterprise Edition - Version 9.2.0.1 to 12.1.0.2 [Release 9.2 to 12.1] Information in this document applies to any platform. ***Checked for relevance on 26-Sep-2012*** ***Checked for relevance on 8-Jul-2015*** SYMPTOMS Adding a Tablespace / Datafile in Primary Databas...
ALTER TABLESPACE "TBLSPCE_NAME" ADD DATAFILE 'D:\DATABASE\MY_DATFILE2.ORA' SIZE 100M; Upvote 0 Downvote Not open for further replies. Similar threads J Locked Question Oracle Simphony - Adding tip out percentages to Employee Tip Report 1 jj10438 Feb 7, 2025 Oracle: All...
In my environment I have a table with around 5 million records and two indexes. I want to know what will be the effect on the existing indexes, if i add a new column to this table i.e. whether indexes are dropped and created again or updated somehow or there is no effect at al...