I have one database for general use in a powerful server 2003 with 16 Gb physical memory. The server is exclusively for this database. How to optimize Oracle database SGA to take full advantage of...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_24118366.html
Here are what I want to get:
test.sql
define v1=&1
-- v1=AB,but can be the other values
define v2=&2
-- v2=test.log
spool &v1_&v2
-- expect spool to a file called AB_test.log
select table_n...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_24304016.html
Want to use the data pump API with option CONTENT=DATA_ONLY . How to do that?
http://www.experts-exchange.com/Database/Oracle/10.x/Q_24321361.html
in impdp, I can import a table to different schema as REMAP_SCHEMA=A:B from schema A to B, but is there any equalvent statement in DBMS_DATAPUMP, which I will do the same as impdp?
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_24326372.html
In Oracle database, if you issue the following command:
describe table1
Name Null? Type
col1 NOT NULL VARCHAR2(20)
col2 ...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_24332306.html
Would like to get the sql statements for a trigger in Oracle database. For example,
--trigger tr1
CREATE OR REPLACE TRIGGER tr1
......
end;
What sql statement should I issue to see the tr1's ...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_24148047.html
Created a PK in a table (col1, col2) and checked it.It's status enabled. I inserted two identical rows, but there is no violation of PK. For the error, where to check the error?
http://www.experts-exchange.com/Database/Oracle/10.x/Q_24302934.html
