Archive for May, 2009

Oracle IMPDP: Wildcard hacking

Sometimes you want to use datapump import (impdp) for smart problems. An example is excluding (or including) a subset of objects, like tables. The usual way to do so is the EXCLUDE keyword.
(Footnote: All examples in this post are written for a parameter file, so don’t forget a proper quoting for your shell if you are using them on command line.)

(1) The basic syntax for excluding the table EMPLOYEES_1 from import is:

EXCLUDE=TABLE:EMPLOYEES_1

(2) More sophisticated is the use of an IN() statement for more than one table, let’s ignore EMPLOYEES_1, CARS_1 and TRUCKS_1: Read more…


By Martin Klier in Oracle  .::. Read Comments (2)

Oracle: Query/Monitoring autoextend of datafiles

Did you ever wonder how to see whether your datafile is on autoextend or not, or monitor the autoextension to keep eyeballs on target? The Oracle EM is a simple tool for that, but some people do prefer the direct query.

See a little example to query or autoextend a datafile.

select * from dba_data_files where tablespace_name='USERS';

alter database datafile &datafilenumber AUTOEXTEND
        on next &increment maxsize &maxsize;

Take care
Usn


By Martin Klier in Oracle  .::. Read Comment (1)


You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.