Oracle - ASGAUR

1. EXPORT: exp system@test owner=test123 file=d:oracleuser.dmp log=d:oracleuserdump.log rows=y statistics=none feedback=100 indexes=y consistent=y compress=n; (for individual tables=table1,table2,…..) 2. IMPORT: imp system@test fromuser=test123 touser=test123 file=d:oracleuser.dmp log=d:oracleuser11.log ignore=y rows=y indexes=y feedback=100;

Oracle: How to Export / Import Database Schema Read More »

Tuning for Oracle Database on UNIX

Leave a Comment / Aix, HP-UX, Linux, Oracle, Solaris / admin

Operating System Tools Several operating system tools are available to help you assess database performance and determine database requirements. In addition to providing statistics for Oracle processes, these tools provide statistics for CPU usage, interrupts, swapping, paging, context switching, and I/O for the entire system. Common Tools The following sections provide information on common tools:

Tuning for Oracle Database on UNIX Read More »

Solaris 10 and Oracle 10g RAC ASM Device NOT seen

Leave a Comment / Oracle, Solaris / admin

You have a bunch of /dev/rdsk and /dev/dsk entries. Have you run format w/ partition to create a partition on each volume yet? A couple things to remember when doing this (I’m not sure if this is always required, but it’s something I’ve always done on Solaris ASM configurations): 1. Use slice 6 with type

Solaris 10 and Oracle 10g RAC ASM Device NOT seen Read More »