OraFAQ Forum: Server Utilities » Export Utility

Home » RDBMS Server » Server Utilities » Export Utility - Table not accessible

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Export Utility - Table not accessible [message #73399]

Thu, 15 April 2004 10:32

Sachin
Messages: 52
Registered: May 2001

Member

Hi,

I am trying to expot using the following command

exp "system/manager as sysdba" parfile=tkxgsymc2.par silent=y

And parameter file is like this:

tables="MixedCaseIn.JUSTONE"

But I am getting the following error, I don't know why?

About to export specified tables via Conventional Path ...
EXP-00011: SYS.MixedCaseIn.JUSTONE does not exist
Export terminated successfully with warnings.

Cay anyone please suggest why I am getting this error?

I can see the tables when I login as user MixedCaseIn but the table is not visible when I login as system/manager as sysdba

I am working on AIX 5.2 and Oracle 9.2.0.4.

Thanks,

Sachin

Report message to a moderator

Re: Export Utility - Table not accessible [message #73400 is a reply to message #73399]

Fri, 16 April 2004 02:21

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

are ya sure that it is a table?
it might be a synonym or view?
check user_tables !

Report message to a moderator

Re: Export Utility - Table not accessible [message #73411 is a reply to message #73400]

Sun, 18 April 2004 23:18

Sachin
Messages: 52
Registered: May 2001

Member

Hi,

Yes it is a table, which I just created before using export utility.

But the table entry is not there in user_tables when I login as system/manager as sysdba

And when I login as "MixedCaseIn" identified by mixedcasein then table entry is there in user_tables.

I am really confused why i can't see the table entry? This entry being missing in the user_tables doesnot let me export.

Please help me.

Thanks,

Sachin

Report message to a moderator

Re: Export Utility - Table not accessible [message #73412 is a reply to message #73411]

Mon, 19 April 2004 03:01

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

it is becuase the table is been created in schema MixedCaseIn and NOT IN system.
i dont understand your case.

as per ur posting

exp "system/manager as sysdba" parfile=tkxgsymc2.par silent=y

And parameter file is like this:

tables="MixedCaseIn.JUSTONE"

so u perfectly log in as system and trying to export an table owned by MixedCaseIn.
So the table is Owned by MixedCaseIn and NOT by system

do something like this

bash-2.03$ exp system/mag tables=(mag.emp) silent=y

About to export specified tables via Conventional Path ...
Current user changed to MAG
. . exporting table                            EMP         14 rows exported
Export terminated successfully without warnings.

or

if you want to use a parameter file
bash-2.03$ exp system/manager parfile=par.par

About to export specified tables via Conventional Path ...
Current user changed to MAG
. . exporting table                            EMP         14 rows exported
Export terminated successfully without warnings.
bash-2.03$ cat par.par
tables=(mag.emp) silent=y statistics=none
bash-2.03$

Report message to a moderator

Re: Export Utility - Table not accessible [message #73414 is a reply to message #73412]

Mon, 19 April 2004 06:07

Sachin
Messages: 52
Registered: May 2001

Member

Hi Mahesh,
Thanks for working one my problem, I would try to explain it in details.
The user is "MixedCaseIn" and which is created by system/manager logging in as sysdba.
Now after logging on to Oracle with userid MixedCaseIn, I am creating a table called JUSTONE.
I want to export this table using parmeter file when logged in as system/manager as sysdba. The table is created in the dafault tablespace - SYSTEM.
Further I can see the table when I log in as "MixedCaseIn" but it is not accessible when I log in as system/manager as sysdba.
I hope it explains what I am trying to do.
Now I tried both the options as you said but still of no use.
Please do let me know how can get it working, I am very new to this dba kind of job.
Thanks in anticipation.
Sachin

Report message to a moderator

Re: Export Utility - Table not accessible [message #73415 is a reply to message #73414]

Mon, 19 April 2004 13:39

gulshan
Messages: 19
Registered: January 2004

Junior Member

Donot connect system/manager as sysdba. Just connect it as system/manager.

When u connect as sysdba then u r connected to the sys schema. So just connect as system/manager.

Then it will export successfully.

Report message to a moderator

Previous Topic:	IMP00017 error while importing a user dmp
Next Topic:	SQL Loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 16:31:20 CDT 2024