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?

1 Answer 1


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. ...

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.