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?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
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.
... If you delete and reinsert a row with the Import and Export utilities, for example, then its rowid may change. ...