Tamim Khan tamimdba gmail. And many objects got created and many not due to permission problem. I have a feeling it has to do with SQLPLUS, trying to display its output to the screen, but with the script being run remotely, something goes wrong here Feel free to ask questions on our Oracle forum. Can we start DB with srvctl start DB? I tried the above 2 suggestions - setting the variables inside the script, and also executing the. 
| Uploader: | Mooguzuru |
| Date Added: | 21 December 2011 |
| File Size: | 52.87 Mb |
| Operating Systems: | Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X |
| Downloads: | 67252 |
| Price: | Free* [*Free Regsitration Required] |
Tamim Khan tamimdba gmail. About the Oracle command shell environment, I would rather not modify the login shell and configure it on demand. I looked into google and found that I should run the file catexp.
how to run - General Database Discussions
If you do wish to set the environment automatically, I rather suggest the following: Anybody who can help? SQL has to be run only once when the database is created. Please customize the environment varibles for your own environment.
I can't access sqlplus can i start db with this command in 9i? Resources database java software javascript android java csharp php python ios jquery html sql.
I have a feeling it has to do with SQLPLUS, trying to display its output to the screen, but with the script being run remotely, something goes wrong here Please see my previous response.
Even installation process was successful at the end I got some errors. So I saw many messages which alerted that DBA permission is required. Kindly put some light on it as I do not want to do any mistake with this database now.
I can't recreate the database. And many objects got created and many not due to permission problem. It seems like I cannot paste certain characters into this page.
Take DDL output in Dump file: I don't know what happenend and how to correct this. This mode can be used to export and import all objects that belong to a user. I'm creating a new database manually and I don't know all of the data dictionary scripts that I need to run. I thought of restarting the server and rerun the script catalog. All rights reserved by Burleson.
Catexp sql free - Free Downloads
I tried the above 2 suggestions - setting the variables inside the script, and also executing the. Importing a full export - creating tablespaces first?
You are running Linux, not MS Windows. Also how will I get the data on recreating the new user.
Sql scripts
Should I be able to do this, and am I just missing another variable perhaps? I am still getting the same error though. If you like Oracle tuning, see the book " Oracle Tuning: I can run the script ok, but as soon as I try and run sqlplus moving into OracleI get the error: These parameters can be listed by executing the following commands: On a no problem fresh installation there should be no reason to run this file.
JD Edwards World Gener Hi, I am new to export and import. The way you are executing the script will not set environment specified in. This seems to be the easiest and I can save my data too.
Comments
Post a Comment