ROWID and expdp

Question

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?

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