A question about system development and design? ? ?

kelphen

To redevelop a system similar to the one in use, the specific business is different.
Using oracle + c # .net How does the database inherit the original better?
Regarding the system's user permissions, logs and other tables and frameworks, I want to make full use of the original,
The original system was not developed by me, and the source code is available.
Please give advice and give advice. Thank you!

whbilly

It ’s almost the same. If you consider efficiency, you can consider using the original one

hzy520cf

Based on the original modification, you can consider rewriting your own understanding.

kelphen

The original system oracle is on the aix computer, and the database of the new system will also be on the same computer.
Is it now to create a new database and import the original data?
Or just create a new user on the original database?
What method is better? Please advise

liub950511

method one:

1. Create a new tablespace eg: TbsA
2. Create a new user eg: userA default tablespace TbsA
3. Grant the appropriate permissions to this user
4. Create the corresponding database objects

Method Two:

If the original system is basically consistent with the database structure of the new system, you can also directly exp / imp.

Personally recommend the first method.

yuanin

Since it is on the same machine, create a user.

kelphen

If only one new user is created, it will conflict when using the same table

liub950511

There is no conflict between tables between different users, that is, both user A and user B can have a table called tableA. Of course user A can access user B's table if he has permission.