EXECUTING ORACLE SQL COMMANDS IN UNIX
Ok Sreddy or anyone else
Which directories will the databases be stored in??
this is what I see when login by telnet
SunOS 5.6
login: oracle
Password:
Last login: Thu Feb 1 14:20:17
Sun Microsystems Inc. SunOS 5.6 Generic August 1997
You have new mail.
$ ls
app dbstart.log mbox sqlnet.log
dbshut.log dead.letter profile.bak
$ cd app
$ ls
oracle
$ cd oracle
$ ls
admin doc local product
$ cd admin
$ ls
AUAF FORU IMPR NETP NETT OEM SQLZ TPRO TTST orcl
$ cd auaf
auaf: does not exist
$ exit
The database I want to export for testing would be TTST.
How would I format the export command
Do have to list the database name
example
exp oracle/****@TTST full=y file=TTST.dmp
let me know if this works