Rahul Chanumolu

alter user user_name identified by new_password replace old_password

Following are the queries which can be used to create table space in Oracle DB. CREATE BIGFILE TABLESPACE " TABLESPACENAME " DATAFILE 'C:/oraclexe/app/oracle/oradata/ TableSpaceName .dbf' SIZE 500M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; alter TABLESPACE " TABLESPACENAME " AUTOEXTEND ON MAXSIZE unlimited; CREATE USER USERNAME IDENTIFIED BY PASSWORD DEFAULT TABLESPACE " TABLESPACENAME " TEMPORARY TABLESPACE temp; ALTER USER USERNAME QUOTA unlimited ON " TABLESPACENAME "; grant all privileges to  TABLESPACENAME ; commit;