Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by pete91z

  1. pete91z

    What is the best way to update a large table with a sequence

    alternatively, if space is an issue and your partitions aren't too big individually, you add the new surrogate key column to the table, create a new empty table with the same columns and then do a partition exchange to the new table. You could then use a combination of cursors, varrays/bulk...
  2. pete91z

    export import question.

    expdp and impdp also have parallel options so you can spread the export over several files.
  3. pete91z

    Oracle 10g v.2 query builder

    There are a variety of tools. in our organization favourites are PL/SQL Developer and SQL Navigator. Both have a relatively simple to use GUI, but require a license fee. SQL Developer is also available free from Oracle, but its rather flaky to say the least.
  4. pete91z

    Database Control Underlying Link

    Hi, Didn't realise you were using windows. I'm not totally sure how you set the oracle_sid, whether set oracle_sid=usclus4 does it or not. However, that error appears to be down to dbconsole not being set up. You can use the following command: emca -config dbcontrol db -repos create You'll...
  5. pete91z

    Database Control Underlying Link

    Sorry forgot to mention, set ORACLE_SID to the new database and then try the emctl command.
  6. pete91z

    Database Control Underlying Link

    on the server where you have created the new database try this command: emctl status dbconsole
  7. pete91z

    unexplained archive logs

    Do you have Grid Control or dbcontrol set up? If so can you review database activity for that time?
  8. pete91z

    Full table scans

    It does sound like a possible datatype issue as Dagon suggested. Just out of interest, are you able to add optimizer hints to the code/queries to get the expected behaviour?
  9. pete91z

    rman and figuring out the number of channels

    The rman command 'show all' will show you the default parameters. I think the default for disk is one: e.g. RMAN>show all; .. CONFIGURE DEVICE TYPE DISK PARALLELISM 1; I believe there is an equivalent parameter for sbt_tape if you are using a tape device. Otherwise you need to check your rman...
  10. pete91z

    expdp error

    If this is an NFS mount, there are a few things you can do: 1) set event 10298 in the database (from i think this requires bouncing the database ) 2) get the sysadmin to adjust the rsize and wsize parameters for the NFS mount.
  11. pete91z

    Database Migration

    If you are using Enterprise edition, why not investigate using Oracle Streams to replicate the data?
  12. pete91z

    Database Migration

    If your source and destination O/S are the same, standby would probably be best. At the moment I am looking at migrating a 1tb database from linux to AIX with minimal downtime, and because the endian formats are different, I am using Datapump to create the destination database and Oracle Streams...
  13. pete91z

    sqlplus cannot execute binary file

    have you tried running it like this $ORACLE_HOME/bin/sqlplus?
  14. pete91z

    Oracle migration from HP-UX to AIX

    as well as exp/imp, there's also Datapump and the transportable tablespaces option - well worth looking into, but you will need to check the supported/unsupported types...
  15. pete91z

    creating a table and loading data from flat file

    Never used Toad, but sql*loader has a command line interface: sqlldr help=y hope this helps you get started.
See more

Part and Inventory Search

Back
Top