I can drop the user with cascade. Suggest you figure out why you can't access SQL Plus and fix it. May be this is not really related but have you tried running the script with nohup? Email Subscription Enter your email address to subscribe to this blog and receive notifications of new posts by email. Your database is a mess. The answer depends on what options that you are installing. Can we start DB with srvctl start DB?
| Uploader: | Kikus |
| Date Added: | 6 June 2017 |
| File Size: | 13.68 Mb |
| Operating Systems: | Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X |
| Downloads: | 49426 |
| Price: | Free* [*Free Regsitration Required] |
If not, recreate the database. I am still getting the same error though. Catexp.sqo there any way to avoid it and make it work without specifying full path.
OraFAQ Forum: Server Utilities » Running and
The way I see it, your problem is that you are trying to execute or maintain Oracle as root, which is wrong. Drop the user, connect as SYS and rerun the scripts. Tamim Khan tamimdba cwtexp.sql. Email Subscription Enter your email address to subscribe to this blog and receive notifications of new posts by email.
Let me know if this works. May be this is not really related but have you tried running the script with nohup?
Your database is a mess. Search BC Oracle Sites. Keep in mind that. So I am pleased to see your suggestions about cagexp.sql problem. By continuing to use this website, you agree to their use.
ORACLE Database Discussions
If you actually ran dbca "without error" your own words then you would NOT be getting error messages I tried the above 2 suggestions - setting the variables inside the script, and also executing the. Anybody who can help? As long as you keep the.
It is on a similar path in windoze. Good idea, but same error unfortunately post your login script 1. When exporting, database objects are dumped to a binary file which catrxp.sql then be imported into another Oracle database. I was facing some problem with export option. If you are able to determine what is correct, what is wrong, what are the consequences and how to fix then do it.
But if I import the exported data for tables, viewsprocedures etc.
If you like Oracle tuning, see the book " Oracle Tuning: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.
Here are the sub-scripts within catalog.
Oracle’s export (exp) and import (imp) | Tamim DBA's Blog
What were you doing with sqlplus? Thanks for your help, Soni Report message to a moderator.
This will help to execute this batch file against number of servers without changing the code. Thanks for your help. First, about "dbca command not found" error. Join other followers Sign me up! Hi Michel, As I told you in my first post that I am new to this and need your help on this.
And if I have to drop it anyway then what should I do after these steps to get wyeth user back: Take DDL output in Dump file: Top Create a free website or blog at WordPress.
No comments:
Post a Comment