ROWID and expdp

expdpimpdporacle

Can anyone please tell me if ROWID is also exported in expdp process ans stored in dumpfile.

Can I use the following while importing?

QUERY=table_name:\"WHERE rowid = (select min(rowid) from table_name)\"

to import only certain rowid?

Best Answer

ROWID is the "physical" location of a row, including the internal ID of the object, file number, block number, and position in the block. This is just a pseudocolumn, and it is not exported. It is not even stored in the database. When you move a table, ROWIDs change.

So no, do not use the above.

ROWID Pseudocolumn

... If you delete and reinsert a row with the Import and Export utilities, for example, then its rowid may change. ...

Related Solutions

Oracle impdp – Importing file from remote server

From Oracle Data Pump utilities:

Dump files are read and written directly by the server and, therefore, do not require any data movement to the client.

impdp/expdp unlike imp/exp does not move the data. They only invoke DBMS_DATAPUMP package and actual data movement is done by the Oracle instance. So data pump can access external data the same way as all other Oracle procedures - loading files via directory object or SELECT data via dblink.

Oracle EXPDP using QUERY parameter with results from SELECT

No, there is not.

You have already defined manually the filters for each table, why not use that? Just dynamically generate the parameterfile before running expdp:

select 'QUERY=' || table_owner || '.' || table_name || ':"' || where_condition || '"'
from t_definition;

QUERY=DEV.TBL1:"WHERE CMP_ID=0"
QUERY=DEV.TBL2:"WHERE 1=0"
QUERY=DEV.TBL3:"WHERE SEQ_ID=10 OR CMP_ID=0"
...

Or use DBMS_DATAPUMP.

Best Answer

Related Solutions

Oracle impdp – Importing file from remote server

Oracle EXPDP using QUERY parameter with results from SELECT

Related Question