I guess for fragmentation you will get the information from dba_tables adn dba_indexes  For rebuilding indexes, you should look at the status in dba_objects ...
Hi All, Could you please help me to implement the Oracle Streams. I need to implement Oracle Streams in Table level. I need replicate nearly 60 Tables. if...
sir, I am using oracle 10g server in network. and I am using same oracle 10g server in a local machine. i want transfer data from local machine server to...
ya ignore it.. I created database link . after i can transfer table by table for a particular user.. I need transfer a database server user data to another...
Hi all, I m installing oracle10gR2 on solaris 10.I got confused by kernel parameters.I've searched many posts and followed one for setting kernel parameters as...
Can anybody help me with this ? ________________________________ From: oracleclub@yahoogroups.com [mailto:oracleclub@yahoogroups.com] On Behalf Of Rado,...
Help ! ________________________________ From: oracleclub@yahoogroups.com [mailto:oracleclub@yahoogroups.com] On Behalf Of Rado, Denisa, VF-AL Sent: Tuesday,...
Thanks. PS: Don't forgot; Please reply with all details. nive sha <nive_sha2002@...> wrote: Thanks for response.I have solved the problem. Will rply with...
I want For 1 ---------10 For 2 ---------7 SO not the last contract but one before the last For 1 ---- the last contract is 13 And for 2 the last contract...
yes ________________________________ From: oracleclub@yahoogroups.com [mailto:oracleclub@yahoogroups.com] On Behalf Of Babu B Sent: Wednesday, December 17,...
Hello Martin it works thank you , ________________________________ From: oracleclub@yahoogroups.com [mailto:oracleclub@yahoogroups.com] On Behalf Of Martin...
Thanks a lot Martin.. Babu Martin Andrews <andrewstster@...> wrote: enjoy.. thank you Martin Andrews T +91 9894341624 ... From: "Rado, Denisa, VF-AL"...
hi friends, I am using Oracle 10.2.0.1.0 - beta server after installation it will create default tablespace that is.. Sysaux system undo user then i created...
exp user/password@sid file='location/file' log='location/file' user=schema_name  ftp this file to your test server  if you have this schema in test, drop...
Hello,          Thanks for the reply .But what is the need for schema refreshing taking the export from from the production and importing into ...
the first need from developer or application guy. sometimes they need same type of object or data of production in test to develop code or test something. S....
Hello, Â Â Â We are working on a OEM grid control. I have a small doubt . We need to write a query which shows up the Total space, Used Space , Free space ,...