Recent content by rishiu

I have to Move database from One machine to another. The installation of Oracle is different in both the machines! Any Help will b appreciated.. Regards Rishiu

i emcounter an error 1003 when exporting DataBase...but the exp seem to be exporting row to the dump file.. I m on AIX and version of Oracle is 8.1.6 Thks in Advance..It was working fine till recently.

HOw can I rename the Schema. I know Import/export is one of the option. Is there any Way. I m using 8.1.6.2 Ri

I want to have a Standby database on a remote location. how much Should be by network bandwitdth. I know it depends on lot of factors .But Where can i find some material on this.I mean How will the redo logs size depends on the transaction of the datbase. What is the best way for replication...

Hai there! Thks for the inputs , but it doesn;t sees to b good option bcoz there are hundreds of tables in that schema. Here is what i did. Revoke special permissions from the new users. make quota 0 on sysstem tableaspace, make it form all the tables in default tablespace n then grant the...

I have a user whose default tablespace is SYSTEM, when i export it and import it into another database again it gets imported into the same system tablespace.(although the default tablespace of that new user is USERS) here is the question: How can i change the tablespace for a particular user...

ORA-3113 means the client lost contact with the server process. Most probably because the server process crashed. This is almost always an Oracle bug. Rishiu

I hv already a Database and I want to create another database, Is there any way I can hv different name for SYSTEM tablespace, i mean I want the second datbase to hv a system tablespace like DEVSYSTEM. If yes, What is the syntax? Thks In advance Rishi u

Actually It depends, If u hv freshly installed the database then the Answer is yes, but if lot of tablespace etc have been added then Answer is No. Anyway U can get a feel of ur database by the control file Alter database backup controlfile to trace. Try this and Mail further...

It is Related with JavaVM in Oracle 8i U can refer to http://otn.oracle.com/products/oracle8i/htdocs/jserver_faq/ for more details

What is the difference between Multiple instance on the same database n Oracle parallel server. I also want to know more about running multiple instances on the same database. I already have a datbase , n want to configure it for multiple instances, how can i comminicate etc. Thks & regards...

any help in connecting between databases on NT n Unix platforms.I want to communicate between these databases, any help will b appreciated!

What's so great abt Decode?

Try Doing this By a PL/SQL block.Make one cursor with table1 and other with table2 and passing parameters and Updating I m sure It will work. Regards Rishi u.

Just trying Writing Exit at the end of scriptName.sql I mean sqlplus scott/tiger @r.sql Where as r.sql may b select * from dual; exit; Rishiu