I am not being able to drop my tables using :
drop table <table_name>;
command. It says "the table is referencing primary keys of some other tables as foreign keys." , and when I tried to drop foreign key constraints using :
alter table <table_name> drop constraint <constraint_name>;
statement. It says: "cannot drop constraint", and when I tried to drop column itself on which foreign key constraint was applied, using:
alter table <table_name> drop <column_name>;
statement. It says: "cannot drop column owned by SYS table.". Somebody told me, SYS doesn't has the privileges to drop columns especially when foreign keys constraint are present, and he suggested me to make new User account apart from default SYS and customise all the privileges. Making new user is very lengthy process and I read many articles of making a new user already, but it doesn't help , coz, I've done the installation by choosing the option of "install database software only" and then later created and configured Database using DBCA(Database configuration Assistant ). I might have skipped certain steps or didn't look it properly while using DBCA and just kept the default settings.
Creating a new user requires you to use the CREATE USER privilege and the syntax given in the oracle documentation to create user is :
CREATE USER sidney IDENTIFIED BY out_standing1 DEFAULT TABLESPACE example QUOTA 10M ON example TEMPORARY TABLESPACE temp QUOTA 5M ON system PROFILE app_user PASSWORD EXPIRE;
This is the example I copied from the oracle documentation. Now the problem I am facing is with the PROFILE keyword in the above statement. I don't know what value to fill for PROFILE keyword and moreover the documentation suggests :
"Oracle recommends that you use the Database Resource Manager rather SQL profiles to establish database resource limits. The Database Resource Manager offers a more flexible means of managing and tracking resource use."
Now, when I started looking for Database Resource Manager, I came accross various steps such as:
To administer the Resource Manager in Enterprise Manager:
1) Access the Database Home page.
and it says: The Database Home page is the main database management page in Oracle Enterprise Manager Database Control (Database Control).
It asks to confirm certain steps to access the "DataBase Home Page" such as :
1.) Ensure that the dbconsole process is running on the database host computer.
I checked the dbconsole process by running the following statement on the command prompt :
C:\oracle_base\product\11.2.0\dbhome_1\BIN>./emctl status dbconsole
It showed a warning on the command prompt saying :
"OC4J configuration issue . C:\oracle_base\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_rubbalbhusri-PC_orcl not found."
Note : rubbalbhusri-PC is my system-name(the name I defined for my Operating System)
Now, my question is this :
Is "OC4J_DBConsole_rubbalbhusri-PC_orcl" directory created during installation itself ?
Why, I don't have one( "OC4J_DBConsole_rubbalbhusri-PC_orcl" directory ) ?
What should I do to have one( "OC4J_DBConsole_rubbalbhusri-PC_orcl" directory ) ?
Please don't tell me to install the whole "oracle database 11g" again.
Tell me some repair, which solves this problem, if any ?