Oracle Tips : How to rename oracle database name (DBNAME) and SID
Oracle Tips : How to rename oracle database name (DBNAME) and SID Rename SID and DBNAME (Not change DBID) Example case — > I want to rename sid from OLD to NEW 1. Shutdown...
Tagged: database services
Oracle Tips : How to Create Materialized View (mview) in oracle
Oracle Tips : How to Create Materialized View (mview) in oracle A materialized view is a replica of a target master from a single point in time. The master can be either a master...
Oracle Tips : How to change database character set
Oracle Tips : How to change database character set This article gives a overview of methods to change the database character set . 1. Check NLS_CHARACTERSET Connect to user SYS or SYSTEM SELECT *...
Oracle Tips : How you know memory component size when use automatic storage memory managenent(ASMM)
Oracle Tips : How you know memory component size when use automatic storage memory managenent(ASMM) Oracle Database 10g includes the Automatic Shared Memory Management feature which simplifies the SGA memory management significantly. When automatic...
Oracle Tips : How to use Oracle Function-Based Index (Example)
Oracle Tips : How to use Oracle Function-Based Index (Example) Create test table for testing Function-Based Index CREATE TABLE TEST_TABLE ( ID NUMBER(10) NOT NULL, FNAME VARCHAR2(250) NOT NULL ); Insert sample data into...
Oracle Tips : How to rename or relocation(move) datafiles
Oracle Tips : How to rename or relocation(move) datafiles Example case information : – Move datafile /oracle/oradata/test01.dbf to /oracle/oradata_1/test01.dbf – Tablespace name is ‘TEST’ To rename datafiles, complete the following steps: Take the tablespace...
