Hi Everyone,
I have been working at trying to learn the syntax of this expdp and having a difficult time with it. I follow the instructions and examples to the
“T” yet I still get errors. I have a windows 7 Professional laptop I am using with oracle release 11.2.0.1 instance. I am just working with this simple query from the scott schema and get the following error:
LRM-00101 unknown parameter name 'LOC'
expdp scott/tiger directory=dpump_dir1 dumpfile=scottrows.dmp query=DEPT:"where LOC='CHICAGO'"
The suggested solution in the documents going by the code is to correct the mis spelling. LOC is a column name in the DEPT table of the scott schema.
I just ran the following query with the same parameter and it returned rows.
select * from dept where loc = 'CHICAGO';
Is it me? I am at a loss with this and it is making me doubt my sanity. Is there some documentation that I am not reading? I am already reading the Oracle documents and none of their examples work on my laptop.
What is it about this syntax that I am overlooking??
Thanks for your help in advance.
Al