Showing posts with label DataBase. Show all posts
Showing posts with label DataBase. Show all posts

Oracle: managing password

After a while, oracle user password will expire:

login in as system
select username, account_status from dba_users;
alter user HAIBO_JPMC identified by my_pass;

How to drop database (schema) in Oracle


//List all schema:

SELECT username FROM all_users ORDER BY username; 

//Drop table test_db

drop user test_db cascade;

Quick Establishment on Database

create a user account

create user haibo_comr identified by pass;
grant dba to haibo_comr;

DbHostname: 127.0.0.1
DbPort: 1521
DbDatabase: my_database
DbUsername: Haibo_comr
DbPassword: pass

Script need this kind of information to access to database, so it could create all the tables.

1. build a database quickly---MySQL probably the best option.
2. write an utility to load/unload tables by using xml files as inputs.
3. ORM (object-oriented mapping), so could write Java codes against DB quickly. Hibernate?
4. Store the whole environment: VW Mare image.