|
-
export
Dear Friends,
Pl. look into the following problem:
1) I have various databases on a Unix Box
2) By default the oracle_SId will be set to a database by name GTRN. Hence when I log on to Unix box my oracle_sid will be GTRN
3) I have another database UTL1
4) I have issued the following command to export a user's table, but i get the below mentioned error:
au19ora:GTRN> echo $ORACLE_SID
GTRN
au19ora:GTRN> exp bt/bt@utl1 tables=bt
Export: Release 7.3.3.5.0 - Production on Fri Nov 29 16:53:17 2002
Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
EXP-00008: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00222:
System error message 2
EXP-00024: Export views not installed, please notify your DBA
EXP-00000: Export terminated unsuccessfully
5) But, when I change the environment using . oraenv and set to UTL1, the export runs through successfully. Can someone explain why I am getting an error in step 4 though I am using the Connect string
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|