I have a Oracle 8 database on a VMS server and i do not have access to that servere.
Have another server(windows) with Oracle 9i client installed and it can connect to the above mentioned 8i database without issues. I tried to take an export of a schema from the 8i database connecting with a 9i client from the windows server and it does'nt seem to work ( do not have the exact error msg info) . Is it possible to take a export of a 8i schema connected from a 9i client on a different server? I have taken exports of a 9i , connected with 10g client and 10g export connected witha 11g client, but 8i export with 9i client does'nt seem to work.
Truncate is a DDL Command where as Delete is a DML Command.
Both will delete data from table, but what is the difference between these below statements
truncate table <table_name> ??
delete from <table_name> ??
The first command cannot be …
A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows how to copy a database user from one database to another user DBMS_METADATA. It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.