Hi,
I'm trying to make an export dump file using an sh script. The idea is, when you run the script it prompts you for the name of the schema and it automatically fills the corresponding datapump parameters.
The problem is i can't make correct names for both the dump and logfiles!
Here is my script:
#!/bin/ksh
echo "Enter the name of the old schema to export >: "
read old_schema
expdp system/password directory=datapump schemas=$old_schema dumpfile='"&old_schema".dmp' logfile ='"&old_schema".log'
Anyone knows what's wrong here! I'm quite new creating SH scripts!
Thanks
/Hesi