Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2002
    Posts
    17

    Unanswered: How to delete an Oracle Object

    I want to drop an oracle object created with object type as "java class"
    need to know the steps.

    If i make the 'status' of the object from user_object to 'Invalid',does this solve the purpose...How to permantely remove the object created.


    Need Help.

  2. #2
    Join Date
    Jan 2002
    Location
    italy
    Posts
    39
    Hello!!!
    If you are trying to drop a class that results from the compilation of a Java source in oracle you may drop the source instead of the class:

    drop java source "MyClass"

    and this will remove the class as well.
    Pay attention to the name of the class: java is case sensitive.

    If you loaded your class using loadjava you may drop the same class using the companion utility dropjava.

    Regards,

    astropp
    astropp

  3. #3
    Join Date
    Feb 2002
    Posts
    17
    Thanks ...It is working now..Infact we tried from dos prompt.

    dropjava -u <uid>/<pwd>@connect -v <object_name>


    From sql prompt :
    the syntax would be,
    DROP JAVA {SOURCE|RESOURCE|CLASS} [schema.]object_name


    Thanks a Lot for all..

  4. #4
    Join Date
    Feb 2002
    Location
    Shanghai
    Posts
    3

    This is the dropjava's help

    C:\Documents and Settings\xrr>dropjava -help
    dropjava: Drop classes, jars, resources or properties files for Oracle.
    Normally these are classes previously loaded with loadjava.
    Usage: dropjava [options] classes..jars..resources..properties...
    Options:
    -encoding <encoding> the encoding to be used to read .java files
    -h, -help print out this message.
    -o, -oci8 use JDBC OCI8. The database must be an entry
    from TNSNAMES.ORA file or a Net8 Name-Value list
    -schema <schema> drops from <schema> rather than schema of user
    -s, -synonym drop the public synonym.
    -t, -thin use JDBC THIN. The database must be of the form
    <host>:<port>:<sid> or a Net8 Name-Value list.
    -user user/password@database account and database where to load the
    classes and resources.
    -v, -verbose print some information as it loads the files.


    C:\Documents and Settings\xrr>dropjava -help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •