Oracle: Skipped locked rows in select query

Example

select * from hrm for update skip locked

By using this query, locked rows will not shown in query.

Oracle : Import from one user to another user

Example

imp scott/tiger@example file=<file>.dmp fromuser=<source> touser=<dest>

imp nanotouser/nanotouserpass@nanodb  file=/soft/nanodb.dmp log=/soft/nanodb.log fromuser=nanouser touser=nanotouser